select * from database1.table1 where column1 not in(select column1 from database2.table2 where order_date>sysdate-1)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)