‎12-18-2019 12:02 AM
‎01-16-2020 05:52 PM
Left Join (Select
tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion
From
tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
tblSoftwareUni.softwareName Like 'Autocad 2011%'
And tblSoftwareUni.softwareName Like '%Autodesk Material LIbraries 2011%'
And tblSoftwareUni.softwareName Like '%Autodesk Revit 2013%') As SoftwareCheck ...
Left Join (Select
tblSoftware.AssetID,
tblSoftwareUni.softwareName,
tblSoftwareUni.SoftwarePublisher,
tblSoftware.softwareVersion
From
tblSoftware
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where
tblSoftwareUni.softwareName Like 'Autocad 2011%'
OR tblSoftwareUni.softwareName Like '%Autodesk Material LIbraries 2011%'
OR tblSoftwareUni.softwareName Like '%Autodesk Revit 2013%') As SoftwareCheck ...
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now