Figured it out:
Select Top 1000000 tblassets.AssetName As [Asset Name],
tsysAssetTypes.AssetTypename As [Asset Type],
tblassets.Domain As Domain,
tblassets.IPAddress As [IP Address],
tblassets.Mac As [Mac Address],
tsysIPLocations.IPLocation As [IP Location],
tblassets.Lastseen As [Last Seen],
tblassets.Lasttried As [Last Tried]
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join lansweeperdb.dbo.tsysIPLocations On tsysIPLocations.LocationID =
tblassets.LocationID
Inner Join lansweeperdb.dbo.tsysAssetTypes On tblassets.Assettype =
tsysAssetTypes.AssetType
Where (tblassets.Domain != 'DOMAIN1' And tblassets.Domain != 'DOMAIN2'
And tsysIPLocations.IPLocation = 'WIFI1') Or
(tblassets.Domain != 'DOMAIN1' And tblassets.Domain != 'DOMAIN2' And
tsysIPLocations.IPLocation = 'WIFI2')