Captain Paralytic wrote:
> I've never come across a post from Bill where he has used this method,
> but I have seen a couple that you did. Maybe I should call it the
> Karwin->Strwaberry query?

I call it an outer join. ;-)

I've suggested this solution to folks a number of times on newsgroups
and forums. I also covered this and other techniques in a presentation
on outer joins at OSCON last July.

http://www.karwin.com/wiki/index.php/SQL_Outer_Joins

Regards,
Bill K.