现在我有个问题
DELETE FROM connections
WHERE "user_b_id" IN
(SELECT "id"
FROM "users"
WHERE 'dharness.student@gmail.com'="email")
但我真正想要的是
WHERE "user_b_id" OR "user_a_id" IN ...
但我不知道怎么做。这个有接线员吗?
最佳答案
如果users.email是唯一的,您可以编写
WHERE (SELECT id FROM users
WHERE email = 'dharness.student@gmail.com')
IN (user_b_id , user_a_id)