acl-access-query.sql

SELECT engine.Name, item.Name, item.[_ItemTypeName], item.Oversize, item.Brand, vehicle.Name, vehicle.Model
FROM (Items0 AS vehicle INNER JOIN Usages0 AS vehicle_join_engine ON vehicle.ItemID = vehicle_join_engine.ParentID) INNER JOIN ((Items0 AS engine INNER JOIN Usages0 AS engine_join_items ON engine.ItemID = engine_join_items.ParentID) INNER JOIN Items0 AS item ON engine_join_items.ChildID = item.ItemID) ON vehicle_join_engine.ChildID = engine.ItemID
WHERE (((engine.[_ItemTypeName])="Engine") AND ((vehicle.[_ItemTypeName])="Vehicle"))
ORDER BY engine.Name;