Re: Nested subquery making me cry
From: Miguel Cruz <mnc_at_admin.u.nu>
Date: Sat, 25 Nov 2000 08:30:45 GMT
Message-ID: <VMKT5.9262$TE3.550649_at_typhoon2.ba-dsg.net>
Date: Sat, 25 Nov 2000 08:30:45 GMT
Message-ID: <VMKT5.9262$TE3.550649_at_typhoon2.ba-dsg.net>
Miguel Cruz <mnc_at_admin.u.nu> wrote:
> What I neglected to mention was that I actually needed all the patients,
> regardless of whether or not any objects had been found in their stomachs.
>
> This is proving tricky. In your first example, no amount of outer joining
> has come up with the results I'm after. In the second, I run into a brick
> wall sooner, because "ORA-01799: a column may not be outer-joined to a
> subquery".
I finally made it work by creating a view and outer-joining to that. This seems like an awfully roundabout way to have to do it. Also a nuisance for app portability. Oh well.
miguel Received on Sat Nov 25 2000 - 09:30:45 CET