视图如下: SELECT tb.*, Son1.theName AS mobAtComType, dbo.view_MobileAtCom.ComName AS mobAtCom FROM (SELECT dbo.mobIn.*, dbo.SysUser.userName AS opMan, dbo.mobileHouse.mobAtComTypeID AS mobAtComTypeID, dbo.mobileHouse.mobAtComID AS mobAtComID FROM dbo.mobIn LEFT OUTER JOIN dbo.SysUser ON dbo.mobIn.opManID = dbo.SysUser.userID LEFT OUTER JOIN dbo.mobileHouse ON dbo.mobIn.mobCode = dbo.mobileHouse.mobCode) tb LEFT OUTER JOIN dbo.DataOneMixSon Son1 ON tb.mobAtComTypeID = Son1.sonID LEFT OUTER JOIN dbo.view_MobileAtCom ON CONVERT(varchar(10), tb.mobAtComTypeID) + 'AND' + CONVERT(varchar(10), tb.mobAtComID) = dbo.view_MobileAtCom.DoubleID
SELECT tb.*, Son1.theName AS mobAtComType,
dbo.view_MobileAtCom.ComName AS mobAtCom
FROM (SELECT dbo.mobIn.*, dbo.SysUser.userName AS opMan,
dbo.mobileHouse.mobAtComTypeID AS mobAtComTypeID,
dbo.mobileHouse.mobAtComID AS mobAtComID
FROM dbo.mobIn LEFT OUTER JOIN
dbo.SysUser ON
dbo.mobIn.opManID = dbo.SysUser.userID LEFT OUTER JOIN
dbo.mobileHouse ON dbo.mobIn.mobCode = dbo.mobileHouse.mobCode)
tb LEFT OUTER JOIN
dbo.DataOneMixSon Son1 ON tb.mobAtComTypeID = Son1.sonID LEFT OUTER JOIN
dbo.view_MobileAtCom ON CONVERT(varchar(10), tb.mobAtComTypeID)
+ 'AND' + CONVERT(varchar(10), tb.mobAtComID) = dbo.view_MobileAtCom.DoubleID