Re: sql works in access, doesnt work in oracle

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Sun, 14 Sep 2003 17:31:05 +0200
Message-ID: <4d29mvs9g3494e9dmm3dtncihb7blp7lv1@4ax.com>

On 20 Aug 2003 14:55:49 -0700, bigbinc_at_hotmail.com (bigbinc) wrote:

>TRANSFORM Count(SSESRehab.Source) AS COS SELECT SSESRehab.SewerShed,
>SSESRehab.PipeID, SSESRehab.Grade, Count(SSESRehab.Source) AS TS FROM
>SSESRehab WHERE (SSESRehab.PipeID = '13940406901T13940407001') GROUP
>BY SSESRehab.SewerShed, SSESRehab.PipeID, SSESRehab.Grade,
>SSESRehab.AssetType PIVOT SSESRehab.strCode
>
>Is there a reason why this sql works in access and not in oracle.

Sure, because Access Sql isn't Oracle SQL

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sun Sep 14 2003 - 10:31:05 CDT