>>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! :-)
Woiks like a chahm!! Leaves me grinnin' from ear to ear. Thanks!!
Jim Finger