* 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?
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
>
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
Here it goes. This is a small schema of the two tables.
Table Employees
i_recid = auto increment UNIQUE KEY
First Name
Last Name
ETC.
Table Contracts
sales_rep = e.i_recid
Contract Date = date of contract
Office = office
So here is what i am trying to do.
Run a