JOINS, I suck at them.
View Single Post
11-12-2007, 05:30 PM
La Vida es Sueño
Join Date: Sep 2007
I thought I'd just extend onto that and give you an example of a few joins. There are:
LEFT JOIN - Used to include data from the left table, but optional on the right table.
RIGHT JOIN - Same as above just other way round.
INNER JOIN - Used to include data that is present in both tables - so like an ID matching up to a foreign ID in the other table.
NATURAL JOIN - Used to match up a pair of items from the 2 tables that have the same field name. ID to ID, for instance.
There are others like OUTER JOIN which I'm sure others will elaborate on, but the top 4 are what I use most :)
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.
View Public Profile
Send a private message to Wildhoney
Visit Wildhoney's homepage!
Find More Posts by Wildhoney