[CLUE-Talk] Cross posting.

[Jed S. Baer]

On Thu, 4 Apr 2002 20:08:38 -0700 (MST)
Randy Arabie <rrarabie at arabie.org> wrote:

> On Thu, 4 Apr 2002, Jed S. Baer wrote:
> 
> > Uh, lesse.

Sorry, can't help myself ...

select nvl(tech.name,'Linus Torvalds'), nvl(talk.name,'Alan Cox')
from
  clue-tech tech,
  clue-talk talk
where
  talk.name = tech.name (+) and
  tech.name is null
union
select tech.name, talk.name
from
  clue-tech tech,
  clue-talk talk
where
  talk.name (+) = tech.name and
  talk.name is null
ORDER BY talk.name;

Pretty sure, now I think on it, the outer join syntax uses parens, no, not
Perens.

-- 
Fight the CBDTPA: http://www.eff.org/alerts/20020322_eff_cbdtpa_alert.html

"Those who expect to reap the blessings of freedom must, like men,
 undergo the fatigue of supporting it." - Thomas Paine