access sql语句报错，在sqlserver里面是好的。求救！在线等！
程序员文章站
2022-04-04 13:08:43
...
语法错误 (操作符丢失) 在查询表达式 'ur.Uid2=[Uid] inner join (select * from Reservation)r on ur.Tid2=r.Tid' 中。 语句：select * from(select [Uid] as Uid2,Tid as Tid2,Time from UserReservation)ur inner join (select * from UserMessages)u on
语法错误 (操作符丢失) 在查询表达式 'ur.Uid2=[Uid] inner join (select * from Reservation)r on ur.Tid2=r.Tid' 中。
语句：select * from(select [Uid] as Uid2,Tid as Tid2,Time from UserReservation)ur inner join (select * from UserMessages)u on ur.Uid2=[Uid] inner join (select * from Reservation)r on ur.Tid2=r.Tid
怎么解决？急啊！