Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT (tableB."res"/tableA."res") AS "res" FROM (SELECT COUNT(*) AS "res" FROM "ORDERFORM") tableA, (SELECT SUM(pp.PRICE*oi.COUNT) AS "res" FROM "ORDERITEM" oi JOIN "PRODUCTPRICE" pp ON pp.PRODUCTPRICEID=oi.PRODUCTPRICE_PRODUCTPRICEID) tableB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement