not a single group function [message #19101] |
Thu, 28 February 2002 06:04 |
Krista
Messages: 3 Registered: February 2002
|
Junior Member |
|
|
I am getting the following error on my select:
select purch_code, purch_id, net_name,
net_code, net_enroll_ind,
count(perdhis_open_enroll_ind), to_char(net_capture_date,'DD-MON-YYYY')
from purchase, history, customers, orders
ORA-00937: not a single-group group function
would I have to group by here by all the columns selected?
Thank you in advance
|
|
|
Re: not a single group function [message #19105 is a reply to message #19101] |
Thu, 28 February 2002 06:52 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
select purch_code, purch_id, net_name,
net_code, net_enroll_ind,
count(perdhis_open_enroll_ind), to_char(net_capture_date,'DD-MON-YYYY')
from purchase, history, customers, orders
group by purch_code, purch_id, net_name,
net_code, net_enroll_ind,
, to_char(net_capture_date,'DD-MON-YYYY')
|
|
|