Well, I do, though I'm not surprised that I shouldn't. I still don't know anything about left, right, inner, and outer joins; they sound like belly buttons to me :-)
The best thing to do is find a website with some sample data and sample queries and see how they actually work yourself. The 'direction' of a join simply refers to the tables in the query itself, assuming its written left to right; so a LEFT join joins the table to the RIGHT of it to the one to the LEFT of it, using data from the LEFT one and then finding the matching data (from the ON) in the RIGHT one. Reverse RIGHT, LEFT above for RIGHT JOIN. The others will make more sense when you get that.
-- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
