It depends on the databse provider. For example the latest version of MySQL supports multiple tables in the DELETE statement much the same as in the SELECT statement. However the best and most reliable way to do it is to use lots of DELETE statements which delete one record at a time. This is slow though and you can only do around 30 deletions before the script times out normally.<BR><BR>The other approach you can take it to have an extra column on your table called "deleted". Set it from 0 to 1 when you want to delete it. Make your code that displays/queries the databse check for "deleted" being equal to 0. You can then write an admin script that will go through the databse at the end of the day and actually delte any records where "deleted" is equal to 1.