MS Access的多表联查问题 大家看看啊

Question

在access中用四个表联查，以下语句在sql server中通过，可是在
access中提示from子句错误，我没办法了，大家帮忙啊
SELECT DISTINCT a.Device_ID,a.Device_Name,
                              a.Device_IP,a.Device_Mac,
                              a.Device_Password,a.Device_ControlPort,                              a.DeviceType_name,a.DeviceClass_name,
                              a.Device_IPMask,a.Device_Gateway,
                              a.IPCAMERA_MULTIDESTIP as Device_MultiCastIP,
                              a.IPCAMERA_MULTIDESTVIDEOPORT as Device_MultiCastVideoPort,
                              a.IPCAMERA_MULTIDESTAUDIOPORT as Device_MultiCastAudioPort,
                              a.IPCAMERA_RECEIVEAUDIOPORT ,
                              DEVICE_TvWallAppendInfo.TVWALL_AUDUIBASEPORT,
                              DEVICE_TvWallAppendInfo.TVWALL_VIDEOBASEPORT,
                              DEVICE_TvWallAppendInfo.TVWALL_WORKMODE 
                         FROM DEVICE_TvWallAppendInfo right join 
                              (select DEVICE_IpcameraAppendInfo.IPCAMERA_RECEIVEAUDIOPORT,
                                      DEVICE_IpcameraAppendInfo.IPCAMERA_MULTIDESTAUDIOPORT,
                                      DEVICE_IpcameraAppendInfo.IPCAMERA_MULTIDESTVIDEOPORT,
                                      DEVICE_IpcameraAppendInfo.IPCAMERA_MULTIDESTIP,
                                      b.Device_ID,b.Device_Name,b.Device_IP,b.Device_Mac,
                                      b.Device_Password,b.Device_ControlPort,
                                      b.DeviceType_name,b.DeviceClass_name,b.Device_IPMask,b.Device_Gateway 
                                from DEVICE_IpcameraAppendInfo right join 
                                       (select DeviceBaseInfo.Device_ID,DeviceBaseInfo.Device_Name,
                                               DeviceBaseInfo.Device_IP,DeviceBaseInfo.Device_Mac,
                                               Devicebaseinfo.Device_Password,DeviceBaseInfo.Device_ControlPort,
                                               DeviceTypeInfo.DeviceType_name,DeviceTypeInfo.DeviceClass_name,
                                               DeviceBaseInfo.Device_IPMask,DeviceBaseInfo.Device_Gateway 
                                        from DeviceBaseInfo join DeviceTypeInfo on DeviceBaseInfo.Device_TypeID=DeviceTypeInfo.DeviceType_ID
                                       )b on b.Device_ID=DEVICE_IpcameraAppendInfo.Device_ID
                                )a on a.Device_ID=DEVICE_TvWallAppendInfo.Device_ID

Answer 1

形式应该如下
select a.*,b.*,c.* from (a left join b on a.id=b.id) left join c on a.id=c.id
层次括号access必需的