Re: sql works in access, doesnt work in oracle

From: Thomas Kellerer <spam_eater_at_gmx.net>
Date: Thu, 21 Aug 2003 00:07:19 +0200
Message-ID: <bi0reo$mj0$1@svr8.m-online.net>

bigbinc schrieb:
> 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.

Maybe because Oracle doesn't understand TRANSFORM (what is that supposed to do???) and PIVOT ??

I recommend you check out the Oracle SQL syntax http://www.csis.gvsu.edu/GeneralInfo/Oracle/server.920/a96540/toc.htm

Thomas Received on Wed Aug 20 2003 - 17:07:19 CDT