Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sql works in access, doesnt work in oracle

sql works in access, doesnt work in oracle

From: bigbinc <bigbinc_at_hotmail.com>
Date: 20 Aug 2003 14:55:49 -0700
Message-ID: <d1b33313.0308201355.a9f78e7@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.
Received on Wed Aug 20 2003 - 16:55:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US