1
select Klant.* from `Order` left join Klant on Klant.ID = `Order`.KlantID where `Order`.Status = "Nog te leveren";