Delete from multiple tables

Reply

Join Date: Oct 2004
Posts: 7
Reputation: qazs is an unknown quantity at this point 
Solved Threads: 0
qazs qazs is offline Offline
Newbie Poster

Delete from multiple tables

 
0
  #1
Jun 3rd, 2005
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.
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 354
Reputation: Troy is an unknown quantity at this point 
Solved Threads: 5
Troy's Avatar
Troy Troy is offline Offline
Posting Whiz

Re: Delete from multiple tables

 
0
  #2
Jun 9th, 2005
"DELETE FROM table1 WHERE $localTime > Time; DELETE FROM table2 WHERE $localTime > Time";
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC