I want to perform something like this:
from table Jay
where a=b AND c=d AND e=f
I have a, b, c in one sheet and d,e,f,g in other sheet. I am thinking of using inner join with multiple columns but skeptic about the AND operator in above code. Can it be done with inner join with multiple columns?
Please sign in to leave a comment.