Member Avatar for qazs

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.

  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by Troy
Member Avatar for Troy

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.