帮忙看一下
SELECT HardwareType,Model,[ID],KB_NetAssets.Mac,[Name],[User],Department,StrategyGroup,Location,AlertManageType,Brand,Provider
FROM KB_NetAssets INNER JOIN KB_NetAsset_RealtimePCEquipments ON KB_NetAssets .Mac=KB_NetAsset_RealtimePCEquipments .Mac
With NOLOCK
WHERE (KB_NetAsset_RealtimePCEquipments.HardwareType='IP'
OR KB_NetAsset_RealtimePCEquipments.HardwareType='HostName'
OR KB_NetAsset_RealtimePCEquipments.HardwareType='HostUser')
AND KB_NetAssets.Status!=0
ORDER BY KB_NetAssets.Mac ,HardwareType
//////////////////
服务器: 消息 156,级别 15,状态 1,行 5
在关键字 'With' 附近有语法错误。
怎么改呢?