这两个查询结果为什么不一样?
SELECT B.JobNo,B.CustomNo,B.CustomName,B.Operator,B.CargoType
FROM BILL A INNER JOIN JobSheet_SI B ON A.JobID=B.JobID JOIN CustomInfo C ON C.NameCHshort=B.CustomName
WHERE C.CustomID = 40 AND B.WorkTag=99 AND B.JobDate>='2004-1-1'
GROUP BY B.JOBID,B.JobNo,B.CustomName,B.Operator,B.CargoType, B.CustomNo
SELECT B.JobID,B.JobNo,B.CustomName,B.Operator,B.CargoType, B.CustomNo
FROM CustomInfo C INNER JOIN JobSheet_SI B ON C.NameCHshort=B.CustomName
WHERE C.CustomID = 40 AND B.WorkTag=99 AND B.JobDate>='2004-1-1'
GROUP BY B.JobID,B.JobNO,B.CustomName,B.Operator,B.CargoType, B.CustomNo
上面一个查询结果自有一条数据,下面可以查询出2条数据(正确)