Delete all rows in 2 tables with the same query

[Hank Rouse]

DELETE *
FROM TEMP_IMPORT;

Which of course works, but what is the syntax for adding TBL2?

Thanks in Advance.

 

[Rick Brandt]

DELETE *
FROM TEMP_IMPORT;

Which of course works, but what is the syntax for adding TBL2?

Thanks in Advance.

AFAIK you cannot delete from two tables with a single statement. Unless of
course referential intregrity cascades deletes to another table.