我有一个sql查询,它从三个表中检索值 casewhen a.st1_vs1_bag1_onoff=0 and a.logtime=c.logtime then c.st1_vs1_bag1_rb ELSE 0 END as st1_vs1_bag1_rb ,
CASEwhen a.st1_vs10' END as
我写了这个查询:SELECT CASEWHEN UPPER(CM1.Classification1) IN ('A', 'C','G') THEN 'X' WHEN UPPER(CM1.Classification1AS New_Classification, (SELECT COUNT(CASEWHEN UPPER(CM2.Classification1) IN ('A', 'C