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
