Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting records that do NOT match a query
Message
 
To
06/04/1998 21:24:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00089645
Message ID:
00090307
Views:
37
>
>SELECT TABLEB.* FROM TABLEB LEFT OUTER JOIN TABLEA ;
>  ON TABLEB.PK = TABLEA.PK ;
>  WHERE TABLEB.PK != TABLEA.PK
>
>OR
>
>SELECT TABLEB.* FROM TABLEB LEFT OUTER JOIN TABLEA ;
>  ON TABLEB.PK = TABLEA.PK ;
>  WHERE TABLEA.PK = ""
>
>

Justok,

Interesting variations, I don't if they would work or if they would be faster, maybe.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform