Re: A question about table alias and "group by"
- From: sybrandb <sybrandb@xxxxxxxxx>
- Date: Wed, 31 Oct 2007 03:45:40 -0700
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
.
- Follow-Ups:
- Re: A question about table alias and "group by"
- From: syukai
- Re: A question about table alias and "group by"
- References:
- A question about table alias and "group by"
- From: syukai
- A question about table alias and "group by"
- Prev by Date: Re: OUI exits trying to install 10g
- Next by Date: Re: Help: database can not be see from DBCA
- Previous by thread: A question about table alias and "group by"
- Next by thread: Re: A question about table alias and "group by"
- Index(es):
Relevant Pages
|
