> Even if I strip it down further and take out the "in", I still only > get the one Category back when I'd expect all three: > > select xcat.Category > from Category As xcat > left outer join Cases as xc on xcat.CategoryID = xc.CategoryID > where xc.CaseID = 3145 > ; > > Is there another way of specifying an outer join in SQLite?
That's exactly how I did mine. I wrote 'left join' but I don't think that makes any difference. Perhaps if you made your database downloadable we might be able to find out what's going on.
