Delete problem

[jody salt]

If use the following code:

delete from foo, bar using foo, bar;

and both table foo and bar contain some rows, all the contents will be deleted.

NOW!

if one table doesn't contain any rows (e.g. foo) and one table does eg (bar) nothing will be deleted. However I want a single (delete) statement that will delete any of the rows in two different tables regardless of whether one table doesn't have any rows or not.

Any ideas??

This ones got me stumped!

Cheers

Jody