MySQL Forums
Forum List  »  Newbie

Re: SQL Syntax Question
Posted by: Nick Roper
Date: September 01, 2004 02:53PM


To select the values that appear in both tables:

SELECT column_name from t1
LEFT JOIN t2 ON t1.column_name = t2.column_name
WHERE t2.column_name IS NOT NULL;

Nick Roper

Options: ReplyQuote

Written By
September 01, 2004 12:02PM
Re: SQL Syntax Question
September 01, 2004 02:53PM
September 01, 2004 03:05PM
September 01, 2004 03:08PM

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.