MySQL Forums
Forum List  »  Newbie

Re: new to joins
Posted by: Xeon Masters
Date: September 01, 2004 01:46PM


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

SELECT X.lastname, Y.lastname ...

Just use:

SELECT X.lastname...


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)


Options: ReplyQuote

Written By
August 30, 2004 10:03PM
August 31, 2004 02:36AM
August 31, 2004 04:36AM
August 31, 2004 09:36AM
Re: new to joins
September 01, 2004 01:46PM
September 01, 2004 10:52PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.