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')
结果如下:5、6行重复了1、2行,(仔细看OpDesc字段)
结果1:
JobNum OrderNum PartNum OpDesc
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
25402 73 742-012201-01 种树
25402 73 742-012201-01 包装
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
我在上面语句加了distinct,重复值去了,行次序却乱了(仔细看OpDesc字段)
结果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 包装
我只要结果1前面4行,而且要保持行次序不变
JobNum OrderNum PartNum OpDesc
25402 73 742-012201-01 注蜡
25402 73 742-012201-01 蜡镶
25402 73 742-012201-01 种树
25402 73 742-012201-01 包装哪位帮帮忙???
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货