: "Quinten Steenhuis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 2:18 PM
Subject: NULL values in a JOIN
|
| Sql, query
|
| > Hi,
| >
| > I have a field that I need to do a join on. Unfortunately, the column is
| > allowed to be null (and it
Quinten Steenhuis wrote:
> Sql, query
>
> > Hi,
> >
> > I have a field that I need to do a join on. Unfortunately, the column is
> > allowed to be null (and it should be). My plan is to return the literal
> > string 'None' if the column is null, and otherwise to return the joined
> > value. How c
Sql, query
> Hi,
>
> I have a field that I need to do a join on. Unfortunately, the column is
> allowed to be null (and it should be). My plan is to return the literal
> string 'None' if the column is null, and otherwise to return the joined
> value. How can I do this, when the inner join that I
