You might want to use the full join syntax here to be clear on what is
happening.
select
title as Title,
COALESCE(o.name,'None') as Organization
from m
left join o on o.ID = m.organization
Also, notice COALESCE. Much less messy.
Brian.
- Original Message -
From: "Quinten Steenhuis
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
