Archives of the TeradataForum
Message Posted: Fri, 07 Jun 2002 @ 12:40:49 GMT
I want to link to a table to add some fields to my selection. However, this will blow up my selection so i have to do something like distinct in a derived table....
SEL A.id, B.description FROM table1 A INNER JOIN (SELECT distinct B.id, B.description FROM table2 B) as ??? ON (a.id = b.id)
As you can see i don't know what the correct syntax is. Can anyone help me out?
Thanks in advance
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|