MySQL - 选择查询
问题描述:
我几个小时试图进行查询,但我没有成功! :(MySQL - 选择查询
与此查询我选择users_id
并购买了由关键用户的purchase_date
:
SELECT user_id, purchase_date FROM purchases AS p
INNER JOIN keys AS pc
ON p.transaction_id = pc.unique_id
WHERE pc.generator_id = 96768
GROUP BY user_id
现在我想从这些用户后,该谁买选择 例如:SELECT * FROM purchases WHERE user_id = {users of query above} AND purchase_date > {purchase_date of query above}
答
你可以加入子查询表:
SELECT pr.*
FROM purchases pr
INNER JOIN (
SELECT p.user_id, p.purchase_date
FROM purchases p
INNER JOIN keys pc ON p.transaction_id = pc.unique_id
WHERE pc.generator_id = 96768
GROUP BY p.user_id
) p0 ON pr.user_id = p0.user_id AND pr.purchase_date > p0.purchase_date