Home » SQL & PL/SQL » SQL & PL/SQL » How to one table by combining some attribute
How to one table by combining some attribute [message #364] Thu, 07 February 2002 06:01 Go to next message
Chen Wen
Messages: 26
Registered: February 2002
Junior Member
There are two tables: Table1 with column1, column2 and
column3. Table2 with column4, column5 and column6.

Combining column1 and column2. Let them refer to Table2
as foreign key refering to column4 and column5. How to choose records from Table2 that don't appear in Table1 by combining column1 and column2.
Re: How to one table by combining some attribute [message #366 is a reply to message #364] Thu, 07 February 2002 09:03 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select * from table2 where not exists (
select column1 from table1 where
table1.column1=table2.column4 and table1.column2=table2.column5)
Previous Topic: Equivilent to Explain
Next Topic: Re: ORA-02291
Goto Forum:
  


Current Time: Sun Sep 19 12:22:49 CDT 2021