Re: Select w/ group by question

2010-07-14 Thread Scott Mullen
ated vendor. >> > > See "Within-group aggregates" at > http://www.artfulsoftware.com/infotree/queries.php. > > PB > > - > > > On 7/14/2010 9:25 AM, Scott Mullen wrote: > >> I'm having trouble formulating a query to gather the following da

Select w/ group by question

2010-07-14 Thread Scott Mullen
I'm having trouble formulating a query to gather the following data. I can do this via a script, but now it is more or less just bothering me if there is an easy/efficient way to gather the following data from a single query. Example Tables Products Type Cost Vendor_id -