连接查询，A连B，B筛选出多条记录时，选用第一条记录

            select msd.*,sc.*    FROM   MachinesShiftDetails as msd
                                OUTER APPLY (select top 1 * from ShiftCalendars where MachineShiftDetailId = msd.Id) as sc