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_xxxxx_2 A
LEFT OUTER JOIN (select gvorm FROM mi_vm.xxxxx_1 where datum_af is null) as b(gvorm) ON (A.gvorm = B.gvorm);

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

SEL A.gvorm, B.bname_extern_nl
FROM mi_prod.pk_xxxxx_2 A
LEFT OUTER JOIN (select distinct gvorm, bname_extern_nl FROM mi_vm.xxxxx_1) as b(gvorm, bname_extern_nl) ON (A.gvorm = B.gvorm);

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