I have tried to run the below query in marketing cloud and it has thrown below error. "error saving the query field.an expression of non-boolean type specified in a context where a condition is expected, near ','."
Select orderid, orddate from table1 where (orderid,orddate) not in ( select orderid, orddate from table2 )
Can someone help me to resolve the issue.
Thanks in Advance Nikhila