left joins to constants?
882300Oct 4 2011 — edited Oct 4 2011I'm going through some old code, and I found some sql that's puzzling me.
I changed the rest of the query to the newere JOIN syntax, but then I got stuck with this line.
What exactly does it do when you do a left join to a constant? Doesn't the constant always exist, and therefore the it should be the same as not doing a join at all?
select
...
...
where a.status (+)= 'N'
...