delete from table 1

[georgia51390]

I have a question about deleting rows from a table. I have 2 tables of patient data (group number, birthdate, gender). I want to delete all those from table A that are also in table B, but I need for them to have a matching group number, birtdate, AND gender to be deleted. They have to match on all 3 to be removed. Is that possible? Thanks!

 

[dbmsguy]

delete from taba where col1 in (select col1 from tabb where taba.col1=tabb.col1)
and col2 in (select col2 from tabb where taba.col2=tabb.col2)
and
col3 in (select col3 from tabb where taba.col3=tabb.col3)

would delete rows from taba that have predicates in tabb Paul

http://www.dbmsguy.com

 

[dbmsguy]

really more efficient would be:

delete taba from taba a, tabb
where a.col1=b.col1 and a.col2=b.col2 and a.col3=b.col3 Paul

http://www.dbmsguy.com