Posted by Erland Sommarskog on 11/29/05 18:52

(jmartineau@gmail.com) writes:
> Nope, using Oracle9i. Does that change things?

Yes. You should post in comp.databases.oracle, to get more accurate
answers. In this newsgroup you will get syntax that works in Microsoft
SQL Server.

>
> JOIN (SELECT AL2.ACCOUNT_NUMBER, AL2.BAL_LEDGER_CURRENT AS
> DepositBalance, LoanBalance = 0
> *
> ERROR at line 3:
> ORA-00923: FROM keyword not found where expected

That syntax is indeed proprietary to MS SQL Server (and Sybase). I believe
that the ANSI way of writing this is "0 AS LoanBalance" or just "0
LoanBalance". Both syntaxes works on SQL Server, and may work in Oracle.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]