Whats wrong with this select statement???

From: <liam_2e_at_my-deja.com>
Date: 2000/03/09
Message-ID: <8a8jt2$neo$1@nnrp1.deja.com>#1/1

SQL> select s.store_nm
  2 from store s, inventory i
  3 where s.store_id = i.store_id and i.on_hand_qty > (avg (i.on_hand_qty) + 10);
where s.store_id = i.store_id and i.on_hand_qty > (avg(i.on_hand_qty) + 10)

                                                   *

ERROR at line 3:
ORA-00934: group function is not allowed here

Thanks for the help
Liam

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 00:00:00 CST