Archives of the TeradataForum

Message Posted: Thu, 06 Mar 2008 @ 16:07:21 GMT

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

Try this on for size, I think this is what you are after:

     Select E.id, E.name, E.Address, D.Name
        from Employee E
            , Dept D
     Where D.Id = E.Id;

KRT

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