1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| select C1.NUTROV,C1.COPAIO,C1.NUOFOV,C1.DAENOV,C1.CASOOV,C1.retype,
OVIN.NUNAOV,OVIN.CORAOV,OVIN.DANAOV,OVIN.DATECV,OVIN.COPAIC,OVIN.NUCHNA,
OVIN.NUOFME,OVIN.CORAME,OVIN.NUOFPE,OVIN.CORAPE,OVIN.COMRME,
OVIN.COMNAI,OVIN.COTRAN,OVIN.NUOFMP,OVIN.MISIAN,
C2.NUTROV as NUTROV_MERE
from CHEZOV as C1,OVIN left outer join CHEZOV C2 on C2.COPAIO=OVIN.COPAME
and C2.NUOFOV=OVIN.NUOFME
and C2.DAENOV=(select max(DAENOV)
from CHEZOV
where COPAIO = C2.COPAIO And NUOFOV = C2.NUOFOV
and COPACH=C1.COPACH and NUCHEP=C1.NUCHEP
and NOTROU=C1.NOTROU and COSU='0')
where C1.COPAIO = OVIN.COPAIO
and C1.NUOFOV=OVIN.NUOFOV
and C1.COSU='0'
and OVIN.SEXEOV='1'
and OVIN.COSU='0'
and C1.DAENOV=(select max(DAENOV)
from CHEZOV
where COPAIO=OVIN.COPAIO and NUOFOV=OVIN.NUOFOV and COSU='0') |
Partager