Help with Oracle SQL

From: Doug Stone <dstone_at_res-q.com>
Date: Wed, 2 Dec 1998 11:39:12 -0800
Message-ID: <uPj3isiH#GA.391@nih2naaa.prod2.compuserve.com>

Hi. This SQL executes against SQLA, but not Oracle.

Does anyone see why Oracle does not like this view?

CREATE VIEW bbv_proj_avg_dly_vol_1
 (bb_group_id,
 activity_descr_id,
 hiearchy_level_nbr,
 day_nbr,
 sum_val ) AS
select C.bb_group_id,

   C.activity_descr_id,
   C.Hiearchy_level_nbr,
   A.day_nbr,

   ROUND(SUM(A.vol),2) /
   (select COUNT (*)-1
    from bb_group_shift_r E,

      bb_group_activity_std_r F
          where E.bb_group_id = F.bb_group_id) sum_val

from bb_group_proj_volume A,
  shifts B,
  bb_group_activity_std_r C,
  bb_group_shift_r D

where (C.bb_group_activity_std_r_id = A.bb_group_activity_std_r_id)
  and (C.bb_group_shift_r_id    = D.bb_group_shift_r_id)
  and (D.shift_id       = B.shift_id)
  and (C.hiearchy_level_nbr    <> 0)
  and (B.shift_type       = 'I')
group by C.bb_group_id,
   C.activity_descr_id,

   C.Hiearchy_level_nbr,
   A.day_nbr;

Thank you,
Doug Received on Wed Dec 02 1998 - 13:39:12 CST