> On Oct 22, 2015, at 2:41 PM, Michael Dykman <[email protected]> wrote: > > I'm not at a terminal but have you tried grouping by p.pk_ProductID instead > of i.fk...? It is the actual value you are selecting as well as being on > the primary table in the query.
Yeah I tried that - actually the SUM I need is on the JOIN relationship - results should be: 1,Banana,3 2,Orange,5 3,Melon,6 Thanks! Don Wieland [email protected] http://www.pointmade.net https://www.facebook.com/pointmade.band
