* yan zhang > My MySQL LEFT JOIN Syntax as following is wrong? I > cannot get the right result.
What result do you get? > SELECT name, email form T1 LEFT JOIN T2 ON > T1.Snum=T2.Bnum Except from the typo form -> FROM, this looks like a valid statement. Do you get an error? > T1(Snum,name,email,address) > > T2(Bnum, notes, time) > > I wnat ot get the result(name, email, notes). If you want 'notes' to appear in the result, you must mention it in the field list: SELECT name, email, notes FROM T1 LEFT JOIN T2 ON T1.Snum=T2.Bnum -- Roger --------------------------------------------------------------------- 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
