Re: SQL SELECT Cartisian Problem

From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: Thu, 22 Apr 1999 20:23:39 +0200
Message-ID: <7fnpet$7jg$1@weber.a2000.nl>

Richard Murphy

> Name Dogs Cats
> ------ ----- ----
> John dog1 cat1
> dog2 cat2
> dog3

Maybe something like

    break on name

    select t1.name, t2.name, t3.name
    from owners t1
    , (select rownum, owner, name from dogs) t2     , (select rownum, owner, name from cats) t3     where t1.name = t2.owner(+)

    and t1.rownum = t2.rownum(+)
    and t1.name = t3.owner(+)
    and t1.rownum = t3.rownum(+)

    order by 1;

Arjan. Received on Thu Apr 22 1999 - 13:23:39 CDT