https://www.icyphoenix.com/viewtopic.php?f=35&t=5550&p=37198#p37198
-----------------------------------
KugeLSichA
Sat 07 Mar, 2009 16:08

Need Help With SQL Query
-----------------------------------
Hey guys,

i hope someone can help me with the following, and can provide a sql query for it... my mysql knowlegde is to low to do it on my own...

I need to delete all entries in TABLE_1 where topic_xxx from TABLE_2 is set to "0"... in both tables i have the topic_id field... 

something like this, but this did not work:

[code linenumbers=false]DELETE FROM `phpbb_table_1` WHERE `phpbb_table_2`.`topic_xxx` =0;[/code]

can someone help me with this?...

Thanks


