Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL that list all recs from 1 table without match in 2nd??
Message
From
08/09/2000 16:42:04
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL that list all recs from 1 table without match in 2nd??
Miscellaneous
Thread ID:
00414411
Message ID:
00414411
Views:
60
For simple explanation....

I have two tables with these fields:

MASTER
cname = char

DETAIL
cname = char (match above cname)
dorder = date

I need to create a list of all the MASTER records that DO NOT have a matching record in the detail.
I believe this should be a simple SQL select but I can't figure out how to get the joins / where clause
to work right so that I only get the MASTER records.

HELP!!! Something simple and it's driving me nuts!!!
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Next
Reply
Map
View

Click here to load this message in the networking platform