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
