Thanks, John (and Mark), for your comments. I was inspired to write something, because it seems to be hard to find any explanation of LEFT JOIN. I looked through the half dozen SQL books on my shelf and at the reference manuals for MySQL and DB2. All of them had a brief example of the straightforward case, "A LEFT JOIN B ON A.SOMETHING=B.SOMETHING," but none had any discussion or example of a LEFT JOIN with a more complex ON clause or any discussion of what goes in the ON clause or what goes in the WHERE clause. I finally slogged through the definition in the SQL standard. It's quite long and quite arcane, and it may not be readable at all unless you have a degree in math.
I'd be happy to write up a short example for inclusion in the MySQL manual, if there were some indication from MySQL, AB, that it would be included. ----- Original Message ----- From: "John Ragan" <[EMAIL PROTECTED]> To: "Bill Easton" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 19, 2002 11:19 AM Subject: Re: MySQL Left Join Query > > wow! > > that's known as "above and beyond the call of > duty". hope the newbies appreciate your work. > > > > Here's a mini-tutorial on left join that should solve your problem. > > [...] --------------------------------------------------------------------- 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
