加了distinct老是报错

billlyh 2010-02-02 08:31:25

sql语句如下：
SELECT JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc
FROM PUB.JobHead, PUB.JobProd, PUB.OrderHed, PUB.OrderDtl, PUB.ProdGrup,
PUB.JobOper, PUB.Part
WHERE (JobHead.JobNum = JobProd.JobNum) AND
(JobProd.OrderNum = OrderHed.OrderNum) AND
(OrderHed.OrderNum = OrderDtl.OrderNum) AND
(JobHead.ProdCode = ProdGrup.ProdCode) AND
(JobHead.JobNum = JobOper.JobNum) AND (JobHead.PartNum = Part.PartNum) AND
(JobHead.JobNum = '25402')
结果事下：3、4行重复了1、2行，
JobNum OrderNum PartNum OpDesc
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
我只要前面两行，
JobNum OrderNum PartNum OpDesc
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
我想去掉重复的行，在上面语句加了distinct老是报错，哪位帮帮我?

...全文

205 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

--小F-- 2010-02-02

打赏
举报

应该是

SELECT JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc

FROM PUB.JobHead, PUB.JobProd, PUB.OrderHed, PUB.OrderDtl, PUB.ProdGrup,

      PUB.JobOper, PUB.Part

WHERE (JobHead.JobNum = JobProd.JobNum) AND

      (JobProd.OrderNum = OrderHed.OrderNum) AND

      (OrderHed.OrderNum = OrderDtl.OrderNum) AND

      (JobHead.ProdCode = ProdGrup.ProdCode) AND

      (JobHead.JobNum = JobOper.JobNum) AND (JobHead.PartNum = Part.PartNum) AND

      (JobHead.JobNum = '25402') 

      group by JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc

--小F-- 2010-02-02

打赏
举报

报什么错?

feixianxxx 2010-02-02

打赏
举报

...

Zoezs 2010-02-02

打赏
举报



SELECT JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc

FROM PUB.JobHead, PUB.JobProd, PUB.OrderHed, PUB.OrderDtl, PUB.ProdGrup,

      PUB.JobOper, PUB.Part

WHERE (JobHead.JobNum = JobProd.JobNum) AND

      (JobProd.OrderNum = OrderHed.OrderNum) AND

      (OrderHed.OrderNum = OrderDtl.OrderNum) AND

      (JobHead.ProdCode = ProdGrup.ProdCode) AND

      (JobHead.JobNum = JobOper.JobNum) AND (JobHead.PartNum = Part.PartNum) AND

      (JobHead.JobNum = '25402') 

      group by JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc

--这样了？

Zoezs 2010-02-02

打赏
举报



SELECT DISTINCT JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc

FROM PUB.JobHead, PUB.JobProd, PUB.OrderHed, PUB.OrderDtl, PUB.ProdGrup,

      PUB.JobOper, PUB.Part

WHERE (JobHead.JobNum = JobProd.JobNum) AND

      (JobProd.OrderNum = OrderHed.OrderNum) AND

      (OrderHed.OrderNum = OrderDtl.OrderNum) AND

      (JobHead.ProdCode = ProdGrup.ProdCode) AND

      (JobHead.JobNum = JobOper.JobNum) AND (JobHead.PartNum = Part.PartNum) AND

      (JobHead.JobNum = '25402') 

--这样不行？

bancxc 2010-02-02

打赏
举报

SELECT distinct JobHead.JobNum, JobProd.OrderNum, JobHead.PartNum, JobOper.OpDesc 

FROM PUB.JobHead, PUB.JobProd, PUB.OrderHed, PUB.OrderDtl, PUB.ProdGrup, 

      PUB.JobOper, PUB.Part 

WHERE (JobHead.JobNum = JobProd.JobNum) AND 

      (JobProd.OrderNum = OrderHed.OrderNum) AND 

      (OrderHed.OrderNum = OrderDtl.OrderNum) AND 

      (JobHead.ProdCode = ProdGrup.ProdCode) AND 

      (JobHead.JobNum = JobOper.JobNum) AND (JobHead.PartNum = Part.PartNum) AND 

      (JobHead.JobNum = '25402')

报错？纱错