Re: VIEW who works in SQL Server but not in ORACLE

Stef wrote:
> Thank tou for your answer but it still doesn't work. I said something wrong,
> it's ORACLE 8i version.
> Here is the code ( the column Acquit doesn't exist in my table, it's a self
> made in the request)
> Sorry for my English
>
> prd244pr > SELECT TIMESTMP , TRANSTYPE , TAGNME, DSCRPTN,
> 2 (SELECT TAGNAME FROM (
> 3 SELECT TAGNAME FROM RSV_ALM_LOG WHERE
> 4 TRANSTYPE = 'Acked' AND TIMESTMP > T1.TIMESTMP
> 5 AND TAGNAME = T1.TAGNAME)
> 6 WHERE ROWNUM = 1) AS ACQUIT
> 7 FROM RSV_ALM_LOG T1;
> AND TAGNAME = T1.TAGNAME
>
> Error at line 5:
> OAR-00904 : invalid column name
>
>
> Oracle 8i Enterprise Edition Release 8.1.7.4.1 - Production
> PL/SQL Release 8.1.7.4.0 - Production
> CORE 8.1.7.2.1 - Production
> TNS for 32 bit windows : Version 8.1.7.4.0 - Production
> NLSRTL Version 3.4.1.0.0 - Production
>
>
> What can I do.
>
> Thanks
>
>
>

The inner query, the part:
SELECT TAGNAME FROM RSV_ALM_LOG WHERE
TRANSTYPE = 'Acked' AND TIMESTMP > T1.TIMESTMP AND TAGNAME = T1.TAGNAME has no table alias T1, so, there's no column T1.TAGNAME And RSV_ALM_LOG, aliased T1, has a column TAGNME, not TAGNaME!

What you can do, next time, is read... the error message

-- 
Regards,
Frank van Bortel