SELECT
oxs.[销售订单号],omx.[销售编号],omx.[客户订单号],omx.[物料号],omx.[型号],omx.[规格],omx.[用户码],omx.[颜色],omx.[盘具]
FROM [Q8DataBase].[dbo].[销售订单] As oxs LEFT JOIN
[Q8DataBase].[dbo].[销售订单明细] as omx
ON oxs.[销售订单号]=omx.[销售订单号]
WHERE omx.[ID] = (SELECT MIN([ID]) FROM [Q8DataBase].[dbo].[销售订单明细] WHERE [销售订单号]=oxs.[销售订单号])
其中
WHERE omx.[ID] = (SELECT MIN([ID]) FROM [Q8DataBase].[dbo].[销售订单明细] WHERE [销售订单号]=oxs.[销售订单号])
语句的作用是去除子表重复数据
具体结构见Q8项目