select * from PVYKLSLOUP pvyklsloup left outer join PVYKLCAST pvyklcast on pvyklcast.idpk = pvyklsloup.idpk_cast