give this a try ... it sets up the computed column to be accepted by the
group by...

r.odbiorca_id
max(cast(r.data_wyj - r.data_wej as integer)) as o_sklad
count (r.kod_8)
sum(r.waga)
from mgp_role r
group by r.odbiorca_id

Hopes this works for you.

Tony Mays



-----Original Message-----
From: Marcin Bury [mailto:mbury@...]
Sent: Tuesday, May 14, 2002 12:17 AM
To: ib-support@yahoogroups.com
Subject: [ib-support] Group by question


Hi list

I have following select statement:

r.odbiorca_id
cast(r.data_wyj - r.data_wej as integer) as o_sklad
count (r.kod_8)
sum(r.waga)
from mgp_role r

for correct syntax I have to add group by part, but how I can put computed
column there.
One can say - create a view or add computed column to the table. Is there
another solution?

TIA
Marcin



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/