select * from Z0SPOTREBA1 z0spotreba1 left outer join Z0SPOTREBA0 z0spotreba0 on z0spotreba0.idpk = z0spotreba1.idpk_z0spotreba0