Archives of the TeradataForum
Message Posted: Thu, 06 Mar 2008 @ 14:06:30 GMT
Can I write query in Teradata Quarrymen as below
Select E.Id, E.Name, E.Address, (select D.Name from Dept D where E.DId=D.Id) from Employee E;
3706 Syntax Error: expected something between '(' and 'Select'
Any one can suggest me.
Note: I need to write query similarly in my task
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|