How to delete a common row from multiple tables using SQL

Question

I understand you can delete from multiple tables using joins. But, I'm not sure how to do that. I tried using this statement and it didn't work either.

delete trm, val 
from MCS.stg_mdcr_trmntn_rpt trm, MCS.stg_mdcr_vldtn_rpt val
where trm.import_proc_id = 156;

What RDBMS are you using? MySQL supports a multi table delete but SQL Server doesn't for example. — Martin Smith
– Martin Smith, Commented Jul 3, 2013 at 15:16
you can't delete fields like that... cause I suppose trm and val are fields right ? — Laurent S.
– Laurent S., Commented Jul 3, 2013 at 15:17
It almost looks like its not a field, but rather an alias... — logixologist
– logixologist, Commented Jul 3, 2013 at 15:19

Gilbert Le Blanc · Accepted Answer · 2013-07-03 15:25:02Z

1

What's wrong with

delete from MCS.stg_mdcr_trmntn_rpt 
where import_proc_id = 156;

delete from MCS.stg_mdcr_vldtn_rpt
where import_proc_id = 156;

commit;

answered Jul 3, 2013 at 15:25

Gilbert Le Blanc

51.7k6 gold badges73 silver badges119 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to delete a common row from multiple tables using SQL

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related