Re: A question about table alias and "group by"
- From: syukai <chinazhuhui04@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 16:20:42 -0000
On Oct 31, 7:45 pm, sybrandb <sybra...@xxxxxxxxx> wrote:
On Oct 31, 7:56 am, syukai <chinazhuhu...@xxxxxxxxx> 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... ^_^
.
- References:
- A question about table alias and "group by"
- From: syukai
- Re: A question about table alias and "group by"
- From: sybrandb
- A question about table alias and "group by"
- Prev by Date: Re: Help: database can not be see from DBCA
- Next by Date: Using Enterprise Manager 9.2 with a 10g database?
- Previous by thread: Re: A question about table alias and "group by"
- Next by thread: Writing a file on a client pc
- Index(es):
Relevant Pages
|
