OracleSQL-合并“不相关”不相关表中的计数

Oracle / SQL-合并“不相关”不相关表中的计数

试试这个：

SELECt (SELECT COUNT(*) AS good         FROM   table_good         WHERe  widget = 'Widget A'     AND good = 'Y') AS good,        (SELECt COUNT(*) AS bad         FROM   table_bad         WHERe  widget = 'Widget A'     AND bad = 'Y')  AS bad FROM   dual