|
|
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
Navigation:
[Reply to this message]
|