General information
Title:
SELECT - SQL to list records NOT in another table.
I have two similar tables and would like to retrieve all records in the first that are NOT IN the second. In Foxpro 2.6 I used to write statements like:
SELECT tb1_PK FROM table1 WHERE tb1_PK NOT IN ;
(SELECT tb2_PK FROM table2 ;
WHERE somecondition ) ;
INTO CURSOR temp
This style doesn't work in VFP 6.0. I have tried all kinds of combinations but I either get a syntax error or required object is missing.
How do I specify this correctly?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only