1、有两张表customer 和 product,查询有 product 表中两个商品的 customer_id
SELECT *
FROM (SELECT DISTINCT customer_id FROM customer)a
WHERE NOT EXISTS(
SELECT product_key
FROM product b
WHERE NOT EXISTS(
SELECT *
FROM customer c
WHERE b.product_key = c.product_key AND a.customer_id=c.customer_id)
)
2、有表t4 如图,得出结果如图
SELECT t.a,t.b+t1.b AS b,
IF(t.c=t1.c,t.c,1) as c