Of course, that total_price subselect will undoubtedly need to be altered with a where clause too, but you know your data, so play with that some until it's the specific total you want. Then you will have that column containing the total alongside all your others.
Ken Ferguson wrote: > How does this work for you? Does this give you what you need? > SELECT g.gi_id, p.si_id,s.food_store_id,s.gs_price, (select > SUM(gs_price) from fsnep_food_store) AS total_price > FROM fsnep_food_store_purchases p, fsnep_food_store > s,fsnep_food_store_game_info g > WHERE p.food_store_id = s.food_store_id > AND g.gi_id = #cookie.fsnep_bargain_hunt_gi_id# > > > --Ferg > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211627 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
