MySQl LEFT JOIN Syntax

Hi there, My MySQL LEFT JOIN Syntax as following is wrong? I cannot get the right result. SELECT name, email form T1 LEFT JOIN T2 ON T1.Snum=T2.Bnum T1(Snum,name,email,address) T2(Bnum, notes, time) I wnat ot get the result(name, email, notes). Any suggestion, comments? Thanks

Help on cross table Query

Please help me here, and let me know if MySQL can do it or not. All people around me told it should work in SyBASE. Yan Zhang [EMAIL PROTECTED] >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>&g