JOIN Filter

I have two tables A and B. I want to insert data into tables C and D based on join between A and B (A.column = B.column). What is the best way to accomplish this type of task?

IE-------> If column = xyz then insert into table C
IF column = abc then insert into table D
ELSE do_not_insert

Please help.
Regards

Ziggy

The best way...
It seems simplest way to do following two statements

Insert table_C
select * from table_A A,table_B B
where A.col = B.col
and
col = "xyz"


Insert table_D
select * from table_A A,table_B B
where A.col = B.col
and
col = "abc

To make it more efficient,it's probubly better to wrap it into 2 stored procedures and pass column value as a parameter.
For me passing @tablename too and using 1 procedure is
less efficient because of "optimizer stuff" ,but possible as well.

s.

------------
Ziggy at 8/24/99 3:27:48 PM

I have two tables A and B. I want to insert data into tables C and D based on join between A and B (A.column = B.column). What is the best way to accomplish this type of task?

IE-------> If column = xyz then insert into table C
IF column = abc then insert into table D
ELSE do_not_insert

Please help.
Regards

Ziggy