Re: [SQL] How pull

2007-09-24 Thread Matt Magoffin
> On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote: >> Hello, >> >> My SQL skills are limited and I'm struggling with a query where I want >> to >> return a single item of an aggregate join. The query looks like this: >> >> select >> (case >> when agg.avg_rating is null then 0.0 >>

Re: [SQL] How pull

2007-09-23 Thread Filip RembiaƂkowski
On 23/09/2007, Matt Magoffin <[EMAIL PROTECTED]> wrote: > Hello, > > My SQL skills are limited and I'm struggling with a query where I want to > return a single item of an aggregate join. The query looks like this: > > select > (case > when agg.avg_rating is null then 0.0 > when agg.avg_r