Select a.*,b.Name as AreaName,c.Name as PlaceName from Shift a left join Area b on a.AreaID=b.AreaID left join Place c on a.PlaceID=c.PlaceID
在SQL里可以执行而在ACCESS就不行的如何改呢?
...全文
1174打赏收藏
左右连接问题?
Select a.*,b.Name as AreaName,c.Name as PlaceName from Shift a left join Area b on a.AreaID=b.AreaID left join Place c on a.PlaceID=c.PlaceID 在SQL里可以执行而在ACCESS就不行的如何改呢?
Select a.*,b.Name as AreaName,c.Name as PlaceName from (Shift a left join Area b on a.AreaID=b.AreaID) left join Place c on a.PlaceID=c.PlaceID
加个括号就可以,真的好烦的,跟SQL不一样。