Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2008 @ 15:27:50 GMT

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

Try:

     Select E.Id, E.Name, E.Address
     FROM
     Employee E,
     Dept D
     WHERE E.Id=D.Id

     ( --S1
     select D.Name from Dept D where E.DId=D.Id)
     from Employee E;

Quincy Leslie
Sr. Systems Coordinator - EDW/BI

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