OraFAQ Forum: SQL & PL/SQL » How to one table by combining some attribute

Home » SQL & PL/SQL » SQL & PL/SQL » How to one table by combining some attribute

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to one table by combining some attribute [message #364]

Thu, 07 February 2002 06:01

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.

Report message to a moderator

Re: How to one table by combining some attribute [message #366 is a reply to message #364]

Thu, 07 February 2002 09:03

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)

Report message to a moderator

Previous Topic:	Equivilent to Explain
Next Topic:	Re: ORA-02291

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 21:33:50 CDT 2024