摘要： SELECT ROW_NUMBER() OVER (ORDER BY a.ID ASC) AS ID, a.CoachId, a.CoachNo, a.CoachName, isnull(b.Price, 0) CoachPriceFROM Coach a LEFT JOIN dbo.CoachPr... 阅读全文