Mark,

> > Next, why did you choose to use a FULL join? Wouldn't a
> LEFT JOIN been
> > more appropriate?
>
> I want the same records to appear, but with the
> SM_SELECTED.ID field either NULL
> when there is no record, or to have a value if the record
> has been selected.
> Wouldn't a left join exclude the records where the join fails?

I meant to write LEFT OUTER JOIN, not LEFT JOIN.


Sean