SELECT T_PartNo.PartNo, T_Revision.Revision, T_ShopOrder.ShopOrder, [PartNo] & "-" & [Revision] AS Text7
FROM T_ShopOrder INNER JOIN (T_Revision INNER JOIN (T_PartNo INNER JOIN T_Produkt ON T_PartNo.PartNoID = T_Produkt.T4) ON T_Revision.RevisionID = T_Produkt.T5) ON T_ShopOrder.ShopOrderID = T_Produkt.T6;