OraFAQ Forum: Server Administration » Rows in one table not in another -Real Urgent

Home » RDBMS Server » Server Administration » Rows in one table not in another -Real Urgent

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

Rows in one table not in another -Real Urgent [message #373798]

Thu, 10 May 2001 10:03

Vinay Sahitya
Messages: 11
Registered: October 1999

Junior Member

I need to extract rows from one table which are not in other. How do i do this?
I have two tables A and B.
B has uniq index on Col A, B, C and D.

A is a temporary table and has around 50000 rows. We need to insert all those rows from A into B which are not in B. Rows that are already there with a different value for colD need to be inactivated.

Also I have a table C which has only A, B ,and D

from table B I have to insert all those into Table C if Column D is different for a given combination of colA and colB.

Thanks!
Vinay.

Report message to a moderator

Previous Topic:	SQL HELP
Next Topic:	thanks

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 10:05:48 CST 2024