How can I Delete from Multiple Tables based on a Select Query 1

[LeonelSanchezJr]

This query brings back all of the records that I need to delete. How can I delete all of these records across 3 tables?



select * from DESK_ALL
join DESK on DESK_ALL.NUMBER = DESK.NUMBER
join NOTES on DESK.iKEY = NOTES.id
join SOLUTIONS on DESK.iNOTESKEY = SOLUTIONS.id
where 'TEST' in (cRECORDEDBY)

 

[dbmsguy]

one way would be to create a 'delete' trigger on the "desk_all" table, then all you need to do is a delete and the rest would follow through..... Paul

http://www.dbmsguy.com

 

[rajeevnandanmishra]

Hi Leonelsanchezjr,
This will help you in deleting rows from DESK_ALL table, depending on your query.
----------------------------
DELETE DESK_ALL
FROM DESK_ALL
join DESK on DESK_ALL.NUMBER = DESK.NUMBER
join NOTES on DESK.iKEY = NOTES.id
join SOLUTIONS on DESK.iNOTESKEY = SOLUTIONS.id
where 'TEST' in (cRECORDEDBY)
----------------------------

May this help you!