This content has been marked as final. Show 7 replies
927374 wrote:Please give us DDL (i.e. CREATE TABLE statements) and DML (INSERT statements)
I am trying to match table 1 with table 2 by ID.
Table 1 has more IDs then Table 2.
I would like all the IDs From T1 to be matched with Table 2.
IF "ANS" (in table 2) in 9 Then RESULT YES (Table 3) ELSE NO.
( I want to get Table 3)
for your problem.
Are you aware that you have duplicate records for 2 - i.e. "A" occurs twice?
Edited by: Paulie on 16-Apr-2012 01:37
927374 wrote:Well, i guessed at the table names since you never told us EXACTLY what you are dealing with.
But i am getting an error:
ORA-32031: illegal reference of a query name in WITH clause
Line: from table1
I demonstrated the basic idea. You may need to engage a neuron or two to ft my answer in to your question.