Deleting multiple table using single Delete Statement

Vote count:

0

I have 3 tables (for some reason I need to separate these to 3 tables, Im just joining them using LEFT JOIN)

table1

refno
location

table2

refno
description

table3

refno
imagepath

To delete, I need to issue 3 DELETE statements

DELETE FROM table1 WHERE refno = 'variablehere'
DELETE FROM table2 WHERE refno = 'variablehere'
DELETE FROM table3 WHERE refno = 'variablehere'

Is there a way to DELETE from the 3 tables using a single DELETE statement, I mean can I use something like LEFT JOIN in a DELETE Statement?

asked 1 min ago

Ratbucoh

1