Oder anderst gefragt, weshalb funktioniert folgendes Konstrukt nicht?
SQL-Code:
SELECT *
FROM
(Device_Key LEFT JOIN
(Room INNER JOIN
(Floor INNER JOIN
(DeviceType INNER JOIN
(Building INNER JOIN
(Application INNER JOIN
Device
ON [Application].[ApplicationID] =[Device].[ApplicationID])
ON [Building].[BuildingID] =[Device].[BuildingID])
ON [DeviceType].[DeviceTypeID] =[Device].[DeviceTypeID])
ON [Floor].[FloorID] =[Device].[FloorID])
ON [Room].[RoomID] =[Device].[RoomID])
ON [Device_Key].[DeviceID] = [Device].[DeviceID])
WHERE
DeviceType.DeviceType LIKE :DeviceType
AND
Application.Application LIKE :Application
AND
Building.Building LIKE :Building
AND
Floor.Floor LIKE :Floor
AND
Room.Room LIKE :Room
AND
Active = True
ORDER BY Address;