Re: [sqlite] Select with left outer join - Am I going mad or just having a bad day?

[Jay Sprenkle]

On 3/20/06, Ian M. Jones <[EMAIL PROTECTED]> wrote:
> select xcat.Category, count(xc.CaseID) as NumCases
> from Category as xcat
> left join Cases as xc on xcat.CategoryID = xc.CategoryID
> where xc.CaseID in (3145)
> group by xcat.Category
> order by xcat.Category

Is your group by summarizing your results away?