Re: new to joins

[Xeon Masters]

Hi,

Just remove one of *.lastname. The query given by Ramalingam states:

SELECT X.lastname, Y.lastname ...

Just use:

SELECT X.lastname...

or

SELECT Y.lastname...

if you want only one 'lastname' column to be returned.

Now, can somebody explains what is the difference of those JOIN syntax MySQL supports (JOIN, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN, etc)

TIA