Now I have 2 tables, Data table1 column1 column2 A E1 A AE2 A 5 and reference table 2 column1 column2 A E1,AE2,3 what I want to implement is to create a matching flag calculation like the code below: case
when t1.column1 = t2.column1 and t1.column2 in t2.column2
then 1
else 0
end but it has a syntax error. any suggestions? Thanks.
... View more
