Typed query for INNER JOIN (SELECT DISTINCT)?

Viewed 122

Is it possible to create a typed query that produces the following SQL?

SELECT A.*
FROM schema1.Table1 A
INNER JOIN (SELECT DISTINCT column1, column2 FROM schema1.Table2) B ON A.column1 = B.column1
1 Answers
Related