Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple Query?
Message
From
15/04/1999 14:33:42
Edward Pikman
Independent
New York City, New York, United States
 
 
To
15/04/1999 14:31:51
Steve Summers
Pima County Superior Court
Tucson, Arizona, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Simple Query?
Miscellaneous
Thread ID:
00208700
Message ID:
00208702
Views:
22
>I have a cursor with values I do not want in my query. I there a way to say:
> Select * from tablea where not in tableb?
>
>Thanks
>
>:>

Select * From TableA Where TableA.Id NOT IN (Select Id From TableB)
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform