>Does Fox SQL Syntax allow for following?:
>
>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN table2.orderid
>
>Thanks,
Try it like this:
select table1.orderid from table1 where table1.orderid not in (select table2.orderid from table2)
Good luck! :-)
--Todd Sherman
-Wake Up! Smell the Coffee!