Re: SQL Syntax Question
Posted by:
Nick Roper
Date: September 01, 2004 02:53PM
Jeremy,
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
Subject
Written By
Posted
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.