select Inventarnr,Titel,Lieferant.Name as Hersteller from Inventar,Lieferant where Lieferant.id=Inventar.hersteller
