Archives of the TeradataForum

Message Posted: Fri, 07 Jun 2002 @ 13:33:22 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Well,

I'm almost there although i miss the field which this is all about.

SEL count(*)
FROM mi_prod.pk_tosca_2 A
LEFT OUTER JOIN (select geldvorm FROM mi_vm.vgeldvorm where datum_afloopm is null) as b(geldvorm) ON (A.geldvorm = B.geldvorm);

The counting is the same so far but when i insert the description field (B.benaming_extern_nl) then the counting is incremented.

SEL A.geldvorm, B.benaming_extern_nl
FROM mi_prod.pk_tosca_2 A
LEFT OUTER JOIN (select distinct geldvorm, benaming_extern_nl FROM mi_vm.vgeldvorm) as b(geldvorm, benaming_extern_nl) ON (A.geldvorm = B.geldvorm);

	<Prev	Next>		<<First	<Prev	Next>	Last>>