>
> Hi,
>
> I get the foll. error for a group by query:
> This is with the snapshot of Feb 20, and I am running on sparc-solaris 2.6
>
> insert into FTemp1 select item as item1, count(*) as cnt from data group by
> item;
> ERROR: The field being grouped by must appear in the target list
>
> Thanks
> --shiby
Say:
group by item1.
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us