Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2008 @ 16:06:53 GMT

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

Is this just not requiring a Join??

     Select E.Id, E.Name, E.Address, D.Name

     From Employee E

     INNER JOIN Dept D
     On E.DId=D.Id

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