Creating multiple columns using if else or joins

Follow

Jayraj

• October 05, 2018 15:21

Hello everyone,

 

I want to perform something like this:

 

select a,b,c,d,e,f,g

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?

 

Thanks 

0

• 

  Joel Stewart

  • October 05, 2018 15:37

  In the SQL example above, all the data comes from a single table which is similar to a single sheet in Datameer. If you want to use two different sheets (or tables in SQL) and multiple join criteria to all match you'd want to perform an Inner Join with multiple criteria linked using the AND operator. 

  0

  Comment actions Permalink

Please sign in to leave a comment.