Advertisement
MarMar_IV

sdas

Apr 21st, 2015
212
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.24 KB | None | 0 0
  1. 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