具有多个子查询的 MYSQL

Question

您好，感谢您的阅读。

SELECT DISTINCT (thisID and thisNAME) from table1 WHERE thisID IN
(SELECT id from table2 WHERE ... condtions)
OR 
(SELECT id from table3 WHERE ... different condtions)
OR 
(SELECT id from table99 WHERE ...even more conditions)

一旦我有了这些 ID，我需要执行一些选择来提供这些 ID，我只需要从表 1 中选择 thethisID 和 thisNAME。

我必须承认，我在编写查询方面有点超出了我的能力……但我确信我的思路是正确的？有什么帮助吗？？

Answer 1

您的 SQL 非常接近。您需要重复 IN 部分并修复一些外部语法内容:

SELECT DISTINCT thisID, thisNAME
from table1
WHERE thisID IN (SELECT id from table2 WHERE ... conditions) OR 
      thisID IN (SELECT id from table3 WHERE ... different conditions) OR
      thisID IN (SELECT id from table99 WHERE ...even more conditions);