Look at group_concat() here: http://www.sqlite.org/lang_aggfunc.html#groupconcat.
Pavel On Mon, Nov 16, 2009 at 9:07 AM, joseph collins <joec...@hotmail.com> wrote: > > I have this simple table (prodcode, pricecode, pricevalue) > AMA 1 12.35 > AMA 2 12.37 > AMA 3 12.4 > AMA 5 12.41 > AMB 1 12.35 > AMB 2 12.37 > AMB 3 12.45 > AMB 5 12.47 > > I would like the output to be something like this > AMA 1 2 3 5 > AMA 12.35 12.37 12.4 12.41 > AMB 1 2 3 5 > AMB 12.35 12.37 12..45 12.47 > > Can this be done with SQL or do I need some stored procedure and/or higher > level language > > TIA, > > Joe > > _________________________________________________________________ > Bing brings you maps, menus, and reviews organized in one place. > http://www.bing.com/search?q=restaurants&form=MFESRP&publ=WLHMTAG&crea=TEXT_MFESRP_Local_MapsMenu_Resturants_1x1 > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
