使用OUTER APPLY处理左连接数据

select count(*)

from SafeInspectionPlanRecord s --安全巡查记录
OUTER APPLY(

SELECT TOP 1 * FROM safeInspectionplanrecordpointunititem

WHERE recordid =s.c_id
) item