SELECT b.* FROM (SELECT a.user_id , CASE WHEN a.item_id="A" THEN a.s esle NULL END AS A, CASE WHEN a.item_id="B" THEN a.s esle NULL END AS B FROM (SELECT user_id, item_id, sum(amount) AS s FROM tb WHERE item_id = 'A' OR item_id = 'B' GROUP BY user_id, item_id)) b WHERE b.A IS NOT NULL AND b.B IS NOT NULL