RE: Left join question (was: SQL table joins: Join vs. Where)

["Dan Bale" <dbale@xxxxxxxxxxxxx>]

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx / CWilt@xxxxxxxxxxxx
> Sent: Thursday, August 12, 2004 12:51 PM
>
> ifnull is just another name for coalesce.
>
> You do have the SQL reference handy don't you?

Sure do.  It's just that the coalesce post had an example and the ifnull
didn't, so I tried the coalesce without looking that up in the ref and it
worked, so...

But now that you've clued me in, I think I like ifnull better.  I had to
look up a definition of coalesce, and it doesn't seem to match its SQL
function.  IfNull reads much better.  Is there a preference for one or the
other in the SQL community?  The ref doesn't mention one.

Thanks Charles!  And thanks for dropping that weird font! <g>

db