>>Does Fox SQL Syntax allow for following?:
>>
>>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN table2.orderid
>>
>>Thanks,
>
>SELECT table1.orderid FROM table1 WHERE table1.orderid NOT IN (select table2.orderid from table2)
>
>or, in VFP 6.0 this is I think an OUTTER JOIN would do this too.
>
>BOb
I don't think an OUTER JOIN works here. The object is to get records from table 1 that are not in table2 based on orderid. An OUTER JOIN, be it LEFT, RIGHT, or FULL would probably get you those record but would, unfortunately, also include records WHERE table1.orderid IN (SELECT table2.orderid FROM table2).