求SQL语句输出

Question

if isnull(select T_EXP_ORDER.CNTT_NO  FROM  T_EXP_ORDER INNER JOIN
                          T_AC_EXP_ACHIEVE ON 
                          T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
                           JOIN
                          T_PROD_CLASS ON 
                          T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID,'')=''
begin
   PRINT  'S'
end
else
  PRINT  'T'
我想用一个栏位把S或者T输出

Answer 1

---这样试试
if Exists (select A.CNTT_NO  FROM  T_EXP_ORDER A INNER JOIN
                          T_AC_EXP_ACHIEVE B ON 
                          A.PROD_CLASS_ID = B.PROD_CLASS_ID INNER JOIN
                          T_PROD_CLASS C ON 
                          A.PROD_CLASS_ID = C.PROD_CLASS_ID)
   PRINT  'S'
else
   PRINT  'T'

Answer 2

case isnull(select T_EXP_ORDER.CNTT_NO  FROM  T_EXP_ORDER INNER JOIN
                          T_AC_EXP_ACHIEVE ON 
                          T_EXP_ORDER.PROD_CLASS_ID = T_AC_EXP_ACHIEVE.PROD_CLASS_ID INNER
                           JOIN
                          T_PROD_CLASS ON 
                          T_EXP_ORDER.PROD_CLASS_ID = T_PROD_CLASS.PROD_CLASS_ID,'')
when '' then 'S' ELSE 'T' end

Answer 3

Case When Then End
行集函数
涉及你表中的每一行
原来你是这样意思....