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 ','."
Query is-
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