MySQL删除-选择行

Question

我正在尝试从表 subscription 中删除一行，其中有两个外键(id_user 和 id_journal)。我所拥有的信息是来自表user的email和来自表journal的nome。删除的行需要匹配user.email和journal.nome。我找不到解决办法。我该怎么做？

表用户:

id
name
email
password

表格日记:

id
name

表订阅:

id
id_user
id_journal

我尝试的最后两个查询:

DELETE FROM assinatura WHERE (
SELECT  tbluser.id, journal.id
FROM    tbluser, journal
WHERE email = '$email' AND nome = '$nome')

DELETE FROM assinatura 
INNER JOIN tbluser on (tbluser.email = '$email')
INNER JOIN journal on (journal.nome = '$nome')

我尝试了许多其他查询，但没有成功。我认为说我是 MySQL 新手很重要。

Answer 1

DELETE 
FROM Subscription
WHERE id_user IN (
   SELECT      usr.id 
   FROM        user AS usr 
   WHERE       usr.email = INPUT_EMAIL
) 
AND id_journal IN (
   SELECT      jrnl.id 
   FROM        journal AS jrnl 
   WHERE       jrnl.name = INPUT_NAME
)