JIANXYAN的专栏

原创 求多个不同字段的全部记录

SELECT     ISNULL(dbo.mileage.部门编号, dbo.energy.部门编号) AS 部门编号, ISNULL(dbo.mileage.部门名称, dbo.energy.部门名称) AS 部门名称,                       ISNULL(dbo.mileage.线路编号, dbo.energy.线路编号) AS 线路编号, ISNULL(dbo.mil