Re: sql works in access, doesnt work in oracle

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Thu, 21 Aug 2003 02:16:03 +0300
Message-ID: <3f44013a_1@news.estpak.ee>

"bigbinc" <bigbinc_at_hotmail.com> wrote in message news:d1b33313.0308201355.a9f78e7_at_posting.google.com...
> 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.

Could it be because Access is not Oracle? ... and there is no transform command in Oracle...

Tanel. Received on Wed Aug 20 2003 - 18:16:03 CDT