Re: Is it This Join Condition Do-Able? Ooh, ouch, blush

The Subject says it all. (author beats a hasty retreat).

Quoting Dmitri Bichko <dbichko(at)aveopharma(dot)com>:

> I don't see what the problem is.
> Did you mean to insert (3,'C3') into table c, rather than b?

> > create temp table a(keyf int, val text);
> > create temp table b(keyf int, val text);
> > create temp table c(keyf int, val text);
> > insert into a values(1, 'A1');
> > insert into a values(2, 'A2');
> > insert into a values(3, 'A3');
> > insert into a values(4, 'A4');
> > insert into b values(1, 'B1');
> > insert into b values(2, 'B2');
> > insert into c values(2, 'C2');
> > insert into b values(3, 'C3');
> > select keyf, a.val as aval,
> > coalesce(b.val,'Bxx') as bval,
> > coalesce(c.val,'Cxx') as cval
> > from a left join b using(keyf) left join c using (keyf);
> > keyf aval bval cval
> > ---- ---- ---- ----
> > 1 A1 B1 Cxx
> > 2 A2 B2 C2
> > 3 A3 C3 Cxx
> > 4 A4 Bxx Cxx