SQL subquery examples

Join a subquery

SELECT DISTINCT Email FROM Accounts JOIN 
(
    SELECT CouponId, UserId, AccountId 
    FROM Coupons JOIN Users USING(UserId) 
    WHERE CouponType=123
) AS tbl
USING(AccountId);