Delete data from more than one table

[Jerry Swanson]

I can delete data for one table with no problem:
delete from table;

I need to delete data for more than one table.
I tried to run this query: 

delete from account, survey;
//But the query crashes.
 
Any ideas how to delete data for more than one query.
TH

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]