Archives of the TeradataForum

Message Posted: Mon, 03 Jan 2011 @ 16:10:59 GMT

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

When you say you are getting some extra records with same id, then which ID you are referring.

IS it coming from TABLE1 or TABLE2.

Reference :

     TABLE1 LEFT JOIN TABLE2

Regards,

Subhash Gander

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