Hi,
I am trying to delete a set of related record across the whole
database, In tests I
have managed to delete records from 2 tables using the code below.
DELETE FROM phillipsd.tablea using phillipsd.tableb WHERE tablea.one =
2;
but I need to be able to delete from up to 5 different tables, is
there a quick and
simple way of doing this? can someone post an example?
Cheers
David P