SAS nested SQL use

Proc SQL;

Select Fields, (Select Distinct Field from Table2 Where Table1.field1 = Filed2) from table1;

Quit;