mysql - 加入删除

Question

我正在使用 mysql:

• btableA 有 tableB_id 列
• tableB 有 some_interestring_column_on_TableB

我要(下面的伪sql):

delete from tableA 
 where the associated row in tableB (via tableB_id) has  
     some_interestring_column_on_TableB = 'interestingValue'

请帮我把伪sql翻译成真sql。

Answer 1

试试这个:

 DELETE TableA
 WHERE tableB_id IN (
    SELECT id FROM TableB 
    WHERE  interestring_column='pizza');