以下是sql:
SELECT
T.ID AS 'id',
P.PRODUCT_CODE AS 'productCode',
P.PRODUCT_NAME AS 'productName',
P.BRAND_ID AS 'brandId',
T.QUANTITY AS 'distributorId',
W.WAREHOUSE_NAME AS 'keyWord',
P.BIG_UNIT_ID AS 'bigUnitId',
P.LITTLE_UNIT_ID AS 'little_unit_id',
S.SPEC_NAME AS 'categoryId'
FROM
ol_warehouse_product T
LEFT JOIN ol_product P ON T.PRODUCT_ID = P.ID
LEFT JOIN ol_warehouse W ON T.WAREHOUSE_ID = W.ID
LEFT JOIN ol_product_spec S ON T.PRODUCT_ID = S.PRODUCT_ID
WHERE
1 = 1
AND T.DEL_FLAG LIKE '%0%'
GROUP BY
T.ID,
P.PRODUCT_CODE,
P.PRODUCT_NAME,
P.BRAND_ID,
T.QUANTITY,
W.WAREHOUSE_NAME,
P.BIG_UNIT_ID,
P.LITTLE_UNIT_ID,
S.SPEC_NAME
ORDER BY
T.CREATE_DATE DESC
以下是查询结果:
现在想一次性把跟ol_warehouse_product这张表有关联的数据查出来,出现重复数据,找了好久资料都没办法解决,最开始的时候有很多重复数据,通过group by之后现在就剩下两条了,但是数据库ol_warehouse_product表中其实只有一条数据,并且S.SPEC_NAME的值是“块”,不知道从那里跑出来个分,各位大大,给小弟一点建议吧。