Archives of the TeradataForum

Message Posted: Tue, 07 Sep 2004 @ 19:28:13 GMT

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

Dirk,

the problem is that both parts of your join condition is correct for one of the rows in bla2. The first one for the record with genre = 4 and the second condition for the record with genre = 0. That explains the result set. You need to extend the second contion with something like (a.genre is null or a.genre = 0)

Hope that helps

Ulrich

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