Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT o."order_sid"
- FROM "order"."order" o
- INNER JOIN "order".item i ON (i.order_sid = o.order_sid)
- INNER JOIN "product"."product" p ON (p.product_sid = i.product_sid AND is_gift is true)
- INNER JOIN "order".status s ON (s.order_sid = o.order_sid AND s.status = 'completed')
- INNER JOIN "order".status s2 ON (s2.order_sid = o.order_sid AND s2.status_sid <> s.status_sid AND s2.status = 'completed')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement