I have one table which gives me two columns with col1 and col2 values.
These are 1000 plus rows in the table and col1 value need to be deleted from other table Y (complete Row) and same time col2 value need to be deleted from table Z (complete Row)

========= Here is details ========
select *
from m.t_person
=== I get Mem_id and Add_id (two Col Values) these are both numbers betwwen 1 to 999999



DELETE FROM mem.T_person
where Memid = P7582

DELETE FROM Add.T_address
where addid = A1273

==== I use above to delete those column Values for single record.

How I can do all 10000+ records?

Create temp. table or some other ideas?

DELETE FROM t WHERE col in (SELECT ...)

?

alter table table_name
drop column column_name