我有一个MySQL子查询,我需要将它合并到我的主查询中,但我不知道如何实现。我的主要查询如下所示。我想运行它,作为同一查询的一部分,运行子查询并从中获得结果(恰好是一个和),然后在主MySQL语句中比较子查询的结果。主查询 (sign_off_1 = 'Director' or sign_off_2 = 'Director' or sign_off_3
SELECT * FROM ( sum(number*(1-abs(sign(subject-1)))) as sub1,sum(number*(1-abs(sign(subject-2)))) as sub2, sum(number*(1-abs(sign(subject-4)))) as sub4,