Subject Group By [field indexes]
Author Ed Dressel
I am using FB 1.5 and have created a SQL statement that works fine
using a 'group by 1, 2, 3, 4' command--but another user (using FB 1.0)
is getting an exception. I can replace the field indexes with names
except for #2 which is a concantenated field:

SELECT R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...

I tried

GROUP BY R.BUYER, (U1.FNAME || ' ' || U1.LNAME),...

(and variations of it as well) but it does not like the open param.

Any comments on how I might handle this?

Thanks
Ed Dressel