Archives of the TeradataForum

Message Posted: Sun, 05 Oct 2003 @ 16:02:40 GMT

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

Hi,

A third solution can be

Select A.ac1
       ,A.ac2
from  A
      left  join B
        on    A.ac1 = B.bc1
              and B.bc2 > 10
      left  join C
        on    A.ac1 = C.cc1
              and C.cc2 = 11

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