Re: sql works in access, doesnt work in oracle

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.

Access is not Oracle. And Access' SQL isn't ANSI SQL by any wild stretch of the imagination.

If you want to write SQL in Oracle you will need to learn ANSI SQL and the Oracle extensions to the language.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)