两表关联时,另一张表只取一条记录 SELECT field1,field2 FROM table1 AS aOUTER APPLY(SELECT TOP 1 field3,field4 FROM table2 WHERE field3=a.field1)AS b