var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Single Statement to delete record into more tables
I little question for you ... is it possibile to write a SQL statement to delete records in several tables at the same time?
For example if I've two tables involved by join
DELETE <...> from Customers A
INNER JOIN CustomerProperties B ON A.CustomerID=B.CustomerID
I Must use two statement to remove records from both the tables?
Not exactly, but you can approximate it. Check out Cascade to see if it will do what you need.
Or use a trigger...just like in the good old days
when we had to walk uphill to school, in the snow, with no shoes, both ways, all year...
...and man was it rough trying to carry all of those clay tablets!