Re: IN Clause Error
Hi,
The problem might be due to Records in Right side Table
( SEP_Dates_Scheduled) having no corresponding values in
Leftside table ( SEP_Dates) ....Remember we used LEFT JOIN
INNER JOIN joins tables with paired records
LEFT OUTER JOIN joins records in such a way that for each record in LEFT table If there is some record in RIGHT table join them Or else
put NULL values....
Conversely for RIGHT JOIN
If you need the other way round use RIGHT JOIN....
******
Can you give the contents of both tables...?
******
Regards,
Ram.
We Learn the Most When we have to Invent
Subject
Written By
Posted
September 13, 2004 11:08PM
Re: IN Clause Error
September 14, 2004 12:12AM
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.