SELECT LaborDtl.Number01, LaborDtl.Number02, LaborDtl.Number03, eb.EmpID, eb.FirstName, jd.Description FROM PUB.JCDept jd, PUB.EmpBasic eb, PUB.LaborDtl
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模')可能选出n条记录,我想统计出n的具体数值,用count老得不到正确的sql语句,
哪位帮帮我,
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模')可能选出n条记录,我想统计出n的具体数值,用count老得不到正确的sql语句,
哪位帮帮我,
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模')
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模') ????
count(1)
from
PUB.JCDept jd, PUB.EmpBasic eb, PUB.LaborDtl
where
jd.JCDept = eb.JCDept and (jd.Description = '执模')
(select count(1) from FROM PUB.JCDept jd, PUB.EmpBasic eb, PUB.LaborDtl
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模') )
FROM PUB.JCDept jd, PUB.EmpBasic eb, PUB.LaborDtl
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模')
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模')
PUB.LaborDtl这个表没有关联条件。会出现笛卡尔现象。
SELECT LaborDtl.Number01, LaborDtl.Number02, LaborDtl.Number03, eb.EmpID, eb.FirstName, jd.Description
FROM PUB.JCDept jd, PUB.EmpBasic eb, PUB.LaborDtl
WHERE jd.JCDept = eb.JCDept AND (jd.Description = '执模') select @@rowcount as n