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