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. 下面的语句总是出现上面的问题？？请问错在哪里呀
SQL code
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
where1=1and a.SYSID=b.T_BKXXB_PSYSID and a.T_YHDAB_SYSID=c.SYSID
groupby c.dah
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.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
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.SYSID,c.DAH,a.SYSID,a.T_YHDAB_SYSID,b.SYSID,b.T_BKXXB_PSYSID
