我在temp下作如下查詢 select * from sysfilesselect * from sysusersselect count(fileid) from sysfilesselect U.uid , F.fileid , count(F.fileid) from sysusers as U , sysfiles as F
衛生麼在 執行 select U.uid , F.fileid , count(F.fileid) from sysusers as U , sysfiles as F
會出錯 Server: Msg 8118, Level 16, State 1, Line 1
Column 'F.fileid' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
請問是什麼地方我搞錯了???
衛生麼在 執行 select U.uid , F.fileid , count(F.fileid) from sysusers as U , sysfiles as F
會出錯 Server: Msg 8118, Level 16, State 1, Line 1
Column 'F.fileid' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
請問是什麼地方我搞錯了???
select U.uid ,F.fileid ,count(F.fileid) from sysusers as U ,sysfiles as F group by f.fileid,U.uid