两表关联时，另一张表只取一条记录

SELECT field1,field2 FROM table1 AS  a
OUTER APPLY(
SELECT TOP 1 field3,field4 FROM table2 WHERE field3=a.field1
)AS b