Difference between revisions of "SH.PROFITS (view)"

From dbscript Online Help
Jump to: navigation, search
Line 10: Line 10:
  
 
<pre>
 
<pre>
CREATE OR REPLACE SELECT
+
CREATE OR REPLACE VIEW SH.PROFITS AS
 +
SELECT
 
         s.channel_id,
 
         s.channel_id,
 
         s.cust_id,
 
         s.cust_id,

Revision as of 20:10, 24 August 2009

wikibot

view SH.PROFITS


CREATE OR REPLACE VIEW SH.PROFITS AS 
SELECT
        s.channel_id,
        s.cust_id,
        s.prod_id,
        s.promo_id,
        s.time_id,
        c.unit_cost,
        c.unit_price,
        s.amount_sold,
        s.quantity_sold,
        c.unit_cost * s.quantity_sold TOTAL_COST
 FROM   costs c, sales s
 WHERE c.prod_id = s.prod_id
   AND c.time_id = s.time_id
   AND c.channel_id = s.channel_id
   AND c.promo_id = s.promo_id