suggestion:
if you have a windows machine that you can use as
a front end, download a copy of corereader.
http://corereader.com
it lets you create joins by clicking on objects
in your database. you can quickly experiment
with the logic instead of worrying about syntax.
let corereader take care of the details as you
develop the query that you want.
i use it, but it seems to be especially
beneficial to newcomers.
>
> 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
> Yan
--
John Ragan
[EMAIL PROTECTED]
http://www.CoreReader.com/
---------------------------------------------------------------------
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
