Home » RDBMS Server » Server Administration » How to one table by combining some attribute
How to one table by combining some attribute [message #49743] Thu, 07 February 2002 06:00 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.

Report message to a moderator

Re: How to one table by combining some attribute [message #49746 is a reply to message #49743] Thu, 07 February 2002 09:05 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
http://www.orafaq.net/msgboard/newbies/messages/437.htm

Report message to a moderator

Re: How to one table by combining some attribute [message #49763 is a reply to message #49746] Thu, 07 February 2002 20:14 Go to previous message
Satish Mehta
Messages: 6
Registered: January 2002
Junior Member
you can use outer joins to get the relevant data

Report message to a moderator

Previous Topic: Sharing a data block among tables
Next Topic: Temporary Tablespaces
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 12:02:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.