Creating multiple columns using if else or joins


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?




1 comment

  • Avatar
    Joel Stewart

    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. 

Please sign in to leave a comment.