Msg 8120, Level 16, State 1, Line 1
Column 'T_YHDAB.SYSID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
下面的语句总是出现上面的问题??请问错在哪里呀Select c.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
from T_YHSBXXB a,T_BKZFB b,T_YHDAB c
where 1=1 and a.SYSID=b.T_BKXXB_PSYSID and a.T_YHDAB_SYSID=c.SYSID
group by c.dah
Column 'T_YHDAB.SYSID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
下面的语句总是出现上面的问题??请问错在哪里呀Select c.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
from T_YHSBXXB a,T_BKZFB b,T_YHDAB c
where 1=1 and a.SYSID=b.T_BKXXB_PSYSID and a.T_YHDAB_SYSID=c.SYSID
group by c.dah
from T_YHSBXXB a,T_BKZFB b,T_YHDAB c
where 1=1 and a.SYSID=b.T_BKXXB_PSYSID and a.T_YHDAB_SYSID=c.SYSID
group by c.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
from T_YHSBXXB a,T_BKZFB b,T_YHDAB c
where 1=1 and a.SYSID=b.T_BKXXB_PSYSID and a.T_YHDAB_SYSID=c.SYSID
group by c.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
select列表中的字段要么全部出现在group后,如果不在的话一定要出现在聚集函数当中