ORA-00937: not a single-group group function [message #344590] |
Sat, 30 August 2008 17:17  |
joey05in
Messages: 1 Registered: August 2008
|
Junior Member |
|
|
I execute the following query
select sum(shipment.vc_shipment_price),
ord.uc_company,
ord.uc_division
from trlr,
car_move,
stop,
shipment,
shipment_line,
ord_line,
ord
where trlr.trlr_cod = 'SHIP'
and trlr.trlr_id = car_move.trlr_id
and car_move.car_move_id = stop.car_move_id
and stop.stop_id = shipment.stop_id
and shipment.ship_id = shipment_line.ship_id
and shipment_line.ordnum = ord_line.ordnum
and ord_line.ordnum = ord.ordnum
and shipment.shpsts in ('D', 'L', 'S')
and shipment.stgdte >= sysdate
or shipment.loddte >= sysdate
order by ord.uc_company, ord.uc_division
and I get this error
ORA-00937: not a single-group group function
I am new to oracle. Please suggest what change I have to make to my query work..
[Updated on: Sat, 30 August 2008 17:19] Report message to a moderator
|
|
|
|