语法错误: 表别名后应存在“,”或“WHERE”等。

[z6646339001]

select
Distinct sysdate getDate,
A5.LevelMarkName CompName,
A1.usermasterID,
A1.usermastercode,
A3.Code SchedulingCode,
A3.Name SchedulingName,
A3.ID SchedulingRouteID,
A3.VoiceWarnReadyTime,
A4.Name ,
A2.Permissions PermissionType
from Bus_usermaster A1 inner join BUS_SiteManageLine A2
on A1.userMasterID = A2.SchedulingPerson inner join BUS_SchedulingRoute A3
on A2.Route = A3.ID inner join BUS_SiteManage A4
on A2.SiteManage = A4.ID inner join bus_LevelMark A5 on A1.LevelMarkID = A5.LevelMarkID
where A3.ID is not null
and usermastercode = '0308' order by A3.Name Asc这条语句在查询窗口执行没有问题。但是在程序中执行就有问题了，
oracle 数据库 问题出错为“：语法错误: 表别名后应存在“,”或“WHERE”等。
在线等 急急急

[事理]

Distinct sysdate getDate,中间是不是少了个逗号？

[lxl_sports]

1、你试着给最后加一个 分号 “ ； ” 2、查看你如果用的是ADO 那么请仔细查看你的SQL 语句

[事理]

不好意思，看错了，是不是字段后面的空格问题导致的 A4.Name ,

[娃都会打酱油了]

你确认你在程序里执行的sql就是你贴的sql？

[正怒月神]

A2.Permissions PermissionType 这句后面加个空格

[正怒月神]

你这个赋值到sql，因为会自动换行所以没有问题， 但是在程序里就是一个字符串，记得每一行的开头和结尾都加上空格。

[save4me]

试一下

SELECT DISTINCT sysdate 'getDate'
    , A5.LevelMarkName CompName
    , A1.usermasterID
    , A1.usermastercode
    , A3.Code SchedulingCode
    , A3.Name SchedulingName
    , A3.ID SchedulingRouteID
    , A3.VoiceWarnReadyTime
    , A4.Name
    , A2.Permissions PermissionType
FROM Bus_usermaster A1
	INNER JOIN BUS_SiteManageLine A2 ON A1.userMasterID = A2.SchedulingPerson
    INNER JOIN BUS_SchedulingRoute A3 ON A2.Route = A3.ID
    INNER JOIN BUS_SiteManage A4 ON A2.SiteManage = A4.ID
    INNER JOIN bus_LevelMark A5 ON A1.LevelMarkID = A5.LevelMarkID
WHERE A3.ID IS NOT NULL
	AND usermastercode = '0308'
ORDER BY A3.Name ASC

[z6646339001]

不知道什么原因 ，把全部写成一个就好了。 今天我另外一个换成StringBuilder的 StringBuilder sb = new StringBuilder(); sb.Append(" select ") .Append(" A1.CarNo as CarName,A2.TypeName as WBName, A3.RepairShopName as DanWeiName ") .Append(" from Bus_Maintenance A ") .Append(" inner join BUS_Car A1 on A.CarID = A1.CarID ") .Append(" inner join Bus_InOutType A2 on A2.InOutTypeID = A.Maintenancetypeid ") .Append(" inner join Bus_RepairShop A3 on A3.RepaIrShopID = A.RepairShopID ") .Append(" where A1.carID in (" + codeList + ") and (A.DatePlan = '" + dateTime.ToString("yyyy-MM-dd") + "')"); 又是一样的问题

[Doson]

把where 换成 and 试一下

[Sq-Zyz123]

引用 8 楼 z6646339001 的回复:

不知道什么原因 ，把全部写成一个就好了。 今天我另外一个换成StringBuilder的 StringBuilder sb = new StringBuilder(); sb.Append(" select ") .Append(" A1.CarNo as CarName,A2.TypeName as WBName, A3.RepairShopName as DanWeiName ") .Append(" from Bus_Maintenance A ") .Append(" inner join BUS_Car A1 on A.CarID = A1.CarID ") .Append(" inner join Bus_InOutType A2 on A2.InOutTypeID = A.Maintenancetypeid ") .Append(" inner join Bus_RepairShop A3 on A3.RepaIrShopID = A.RepairShopID ") .Append(" where A1.carID in (" + codeList + ") and (A.DatePlan = '" + dateTime.ToString("yyyy-MM-dd") + "')"); 又是一样的问题

你查看你这个stringbuilder生成的sql语句，然后去数据库执行以下看什么问题。

[wlqxm]

像这样的问题一般都是ADO.Net的语句中哪里少了空格造成的。

[秋的红果实]

至少这几句 Distinct sysdate as getDate, A5.LevelMarkName as CompName, A2.Permissions as PermissionType 需要改下

[z6646339001]

不知道是什么原因，用用inner join 有问题 用left join 就没有问题了，结贴 送分