LEFT JOIN Accessories on Orders.AccessorieCode1 = Accessories.AccessorieCode
OR Orders.AccessorieCode2 = Accessories.AccessorieCode
OR Orders.AccessorieCode3 = Accessories.AccessorieCode
select distinct *
from Orders LEFT JOIN Accessories on Orders.AccessorieCode1 = Accessories.AccessorieCode