Web lists-archives.com

Re: Query Summary Help...




> On Oct 22, 2015, at 2:41 PM, Michael Dykman <mdykman@xxxxxxxxx> 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
donw@xxxxxxxxxxxxx
http://www.pointmade.net
https://www.facebook.com/pointmade.band