Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- "Orders".*,
- (SELECT SUM("OrderItems"."cost") FROM "OrderItems" WHERE "OrderItems"."order" = "Orders"."id") AS "summ"
- FROM "Orders"
- WHERE (SELECT SUM("OrderItems"."cost") FROM "OrderItems" WHERE "OrderItems"."order" = "Orders"."id") > 1000;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
