On Wed, Feb 14, 2007 at 17:21:44 -0500, "Edward W. Rouse" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
