帮忙看一下

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' 附近有语法错误。

怎么改呢？