General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
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