Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql and where clauses
Message
From
02/07/1999 10:20:26
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00236881
Message ID:
00236907
Views:
13
I believe that a left join gives you every record from the table before the join statement and all matching records from the records that match the criteria, substituting nulls where the table on the right or after the left join do not match. A right join works the opposite giving you all records from the table after the right join command and matching records from the table before the right join command and substituting nulls where there was no match yet still giving you the records from the table after the join. Does that make since.
Hope this helps
James
Previous
Reply
Map
View

Click here to load this message in the networking platform