how to delete data from 2 tables using same query?

Question

I have 2 tables Patient, Individual Both has some common data, I want to delete record from both tables. What I have tried so far is:

delete p,i from #patient p
inner join #individual i on i.patientUid=p.patientUid
where p.patientuid='test id'

Error:Incorrect syntax near ','.

:(

Googling didn't even take much time than posting the question. — Veera, Dec 05 '14 at 05:26

score 1 · Answer 1 · answered Dec 05 '14 at 05:23

You need two statements, one for each table.

For example:

delete p from #patient p
inner join #individual i on i.patientUid=p.patientUid
where p.patientuid='test id'

delete i from #individual i
inner join #patient p on i.patientUid=p.patientUid
where p.patientuid='test id'

how to delete data from 2 tables using same query?

1 Answers1