954,600 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Delete from multiple tables

Hi,
How can I delete from multiple tables?
I'm using this query and its not working:
"DELETE FROM table1,table2 WHERE
$localTime > table1.Time OR $localTime > table2.Time";

What I hope to achieve is deleting rows from table1 and table2 where
their Time Field is less than $localTime.

Thanks very much.

qazs
Newbie Poster
7 posts since Oct 2004
Reputation Points: 10
Solved Threads: 0
 

"DELETE FROM table1 WHERE $localTime > Time; DELETE FROM table2 WHERE $localTime > Time";

Troy
Posting Whiz
362 posts since Jun 2005
Reputation Points: 36
Solved Threads: 6
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You