ORA-00923未找到要求的 FROM 关键字

来源：百度知道 编辑：UC知道 时间：2024/06/21 05:36:22
SELECT folderGuid as FileGuid,folderName AS name, null as size,creatDate as date ,'' as username,FileContentType='folders',CONVERT(nvarchar, BelongType) AS Type,FilePath='' from Misc_NetHardDiskFolder where parentFolderGuid='46a73c5e-51e1-4056-bedc-6039a26478e5' UNION all SELECT fileGuid as FileGuid,fileName AS name,fileLength AS size,upLoadDate as date,upLoadDisplayName as username, FileContentType as FileContentType,AttachType as Type,FilePath as FilePath from Misc_NetHardDiskFiles where folderGuid='46a73c5e-51e1-4056-bedc-6039a26478e5' 这个有错吗？

SIZE,DATE都是oracle关键字，不能出现在sql的as后面。
写成 size1，date1 会解决“未找到要求的 FROM 关键字”问题。
另外， FILECONTENTTYPE = 'folders'FILEPATH = ''出现的地方也不对，不应该在select子句中，而是在where后。
修改成：
SELECT FOLDERGUID AS FILEGUID,
FOLDERNAME AS NAME,
NULL AS SIZE1,
CREATDATE AS DATE1,
'' AS USERNAME,
CONVERT(NVARCHAR, BELONGTYPE) AS TYPE
FROM MISC_NETHARDDISKFOLDER
WHERE PARENTFOLDERGUID = '46a73c5e-51e1-4056-bedc-6039a26478e5' AND
FILECONTENTTYPE = 'folders' AND FILEPATH = ''
UNION ALL
SELECT FILEGUID AS FILEGUID,
FILENAME AS NAME,
FILELENGTH AS SIZE2,
UPLOADDATE AS DATE2,
UPLOADDISPLAYNAME AS USERNAME,
FILECONTENTTYPE AS FILECONTENTTYPE,
ATTACHTYPE AS TYPE,
FILEPATH AS FILEPATH
FROM MISC_NETHARDDISKFILES
WHERE FOLD