so you want only UNIQUE Field1 from Table1? is that the requirement?

and it's okay to have duplicate entries in Table2?

GROUP BY or ROW_NUMBER can mimic DISTINCT as well