You have to group rows at the second table by linkfield and then you will get the one.
select Table1.*,Table2.id
from etav_test1 t2 ,Table1
where Table1.id = Table2.id group by Table2.id
Results 1 to 2 of 2
Thread: Sybase Top N in SubqueryThreaded View
|
|
|