Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: A question about table alias and "group by"

Re: A question about table alias and "group by"

From: syukai <chinazhuhui04_at_gmail.com>
Date: Wed, 31 Oct 2007 16:20:42 -0000
Message-ID: <1193847642.941249.20250@i13g2000prf.googlegroups.com>


On Oct 31, 7:45 pm, sybrandb <sybra..._at_gmail.com> wrote:
> On Oct 31, 7:56 am, syukai <chinazhuhu..._at_gmail.com> wrote:
>
>
>
>
>
> > i have write a sql, but when put it into excution. some problem was
> > happening...
>
> > the sql is like this:
>
> > select sth from
> > (select sth from A1 A2) B1,
> > (select sth from C1 C2) B2,
> > (select sth from B2 group by sth) B3
> > where
> > B1.conditons compare with B2.conditions
> > And B2.condtions compare with B3.conditions
>
> > but it shows that the B2 table not exists messege. and who can tell me
> > how drill infomation from B2?
>
> > too much thanks... ^_^
>
> You need the WITH statement.
>
> --
> Sybrand Bakker
> Senior Oracle DBA- Hide quoted text -
>
> - Show quoted text -

thanks Sybrand and Brian, for your kindly reply and suggestions to the point... ^_^ Received on Wed Oct 31 2007 - 11:20:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US