| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Edward W(dot) Rouse" <erouse(at)comsquared(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: problem with join |
| Date: | 2007-02-15 04:02:52 |
| Message-ID: | 20070215040252.GA24667@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, Feb 14, 2007 at 17:21:44 -0500,
"Edward W. Rouse" <erouse(at)comsquared(dot)com> wrote:
>
> I tried using coalesce(count(value4)) and case count(value4) = 0
> with no luck. I tried left and right joins and the right join gave me
> the same results while the left join gave me rows like:
That is because neither side of the join had all combinations of numbers
and letters. One approach would be to cross join a table with 'one', 'two',
and 'three' with one with 'a', 'b', 'c', 'd', 'e', and 'f'. And then
left join the query above to it.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2007-02-15 10:24:12 | Re: can someone explain confusing array indexing nomenclature |
| Previous Message | Phillip Smith | 2007-02-14 22:34:16 | Re: Regaring posting a query |