Bill Karwin wrote:

> 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.

Whilst I agree it is an outer join, it is the specifics of the join and
where criteria that enables it to discover the first or last, largest
or smallest, ... of groups of data, that sets it as a useful pattern to
solve a specific problem. Hence the need for a name to call it.