Re: Oracle CBO query cost - retrieve value?

From: Barry Bulsara <bbulsara23_at_hotmail.com>
Date: Sun, 07 Oct 2007 12:44:54 -0700
Message-ID: <1191786294.288400.165070@y42g2000hsy.googlegroups.com>

On Oct 7, 6:19 pm, DA Morgan <damor..._at_psoug.org> wrote:
> Barry Bulsara wrote:
> > Hi, I have a query
>
> > SELECT a,b,c,d
> > FROM table e,f
> > WHERE e.id=f.id
> > AND e.g=something
> > AND h.i=somethingelse
>
> No you don't. Really you don't.
>
> h.i does not exist as nothing is aliased as "h".
>
> Want to try again? <g>
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Ok, I anonymised & simplified the query data incorrectly :-<

SELECT a,b,c,d
FROM table e,f

  WHERE e.id=f.id
    AND e.g=something
    AND f.i=somethingelse

Barry Received on Sun Oct 07 2007 - 14:44:54 CDT