1.NOT EXITS语句
SELECT DISTINCT
c.ID as "id",
c.MED_ID as "medId",
c.SKU as "sku",
c.COMMODITY_NAME as "commodityName",
c.UNIT as "unit",
c.IS_UNIFORM_PRICE as "isUniformPrice",
c.IMAGE_ID as "imageId",
c.DETAIL_IMAGE_ID as "detailImageId",
c.SALE_DATE_BEGIN as "saleDateBegin",
c.SALE_DATE_END as "saleDateEnd",
c.IS_SEARCH as "isSearch",
c.STATUS as "status",
c.REMARK as "remark",
c.CREATE_USER as "createUser",
c.CREATE_TIME as "createTime",
c.UPDATE_USER as "updateUser",
c.UPDATE_TIME as "updateTime"
FROM yiyao_b2c.cmd_commodity c
JOIN yiyao_b2c.cmd_sale_attr s on c.ID=s.CMD_ID
left join yiyao_meta.med_medicine med on c.MED_ID = med.ID
WHERE
NOT EXISTS (
SELECT
t.CMD_ID
FROM
(SELECT mpm.CMD_ID,mpm.EXT_ITEM_ID
FROM
yiyao_meta.med_partner_medicine AS mpm
WHERE
mpm.PARTNER_ID = "xxxx") t //查询出已经同步的商品
WHERE
c.ID =t.CMD_ID AND t.EXT_ITEM_ID IS NOT NULL //过滤已经同步的商品
)
2. 该sql的语义是:查询出没有做过同步的商品
3.标红的的部分是要注意的点