Abfrage über mehrere Tabellen

[DeddyH]

Hallo,

ich habe es nicht getestet, aber versuch es mal so:

SQL-Code:

SELECT A.Code, A.KeyID, D.Access, D.DeviceID
FROM Key A
JOIN Device_Key B ON B.KeyID = A.KeyID
JOIN Device C ON C.DeviceID = B.DeviceID
JOIN Device_User D ON D.DeviceID = C.DeviceID
JOIN User E ON E.UserID = D.UserID
JOIN User_Key F ON F.UserID = E.UserID
AND F.KeyID = A.KeyID
WHERE D.DeviceID = :Param