select KHKStatVKKunden.Kunde,KHKKontokorrent.Matchcode,KHKStatVKKunden.Periode,KHKStatVKKunden.Menge,KHKStatVKKunden.Umsatz,KHKStatVKKunden.Roherloes
from KHKStatVKKunden
Left Join KHKKontokorrent on (KHKKontokorrent.Kto=KHKStatVKKunden.Kunde)
where Periode like '2022%' order by Kunde,Periode