巡检频次信息

SELECT  a.[ID]
      ,[Number] as '次数'
      ,b.Name as '单位'
      ,[Remark]
  FROM [AppBox].[dbo].[Freqs] as a,AppBox.dbo.Turns as b
  where a.Trun_ID = b.ID

原文地址:https://www.cnblogs.com/xihong2014/p/4074195.html