DELETE query

[peasepud]

Hi,

Im trying to delete records from two tables but am hitting a #1064 error but Im totally lost as to whats wrong!

DELETE FROM tbl_topics, tbl_posts WHERE tbl_topics.posts = 0 AND tbl_topics.tid = tbl_posts.topic_id


So basically Im joining table 1 and table 2 on one field but only removing those that have a zero in the posts field of table 1.

Any ideas would be greatly appreciated.

 

[r937]

have a look at the DELETE statement in the manual, it gives several examples, and this is one of them

r937.com | rudy.ca