![]() softwareName Like 'Autocad 2011%' or tblSoftwareUni. softwareVersion From tblSoftware Inner Join tblSoftwareUni On tblSoftwareUni. Assettype Inner Join tsysOS On tblAssets. AssetID Inner Join tsysAssetTypes On tsysAssetTypes. SoftwarePublisher From tblAssets Inner Join tblAssetCustom On tblAssets. SoftwareCheck On SoftwareCheck.AssetID = tblAssets.AssetID ![]() TblSoftwareUni.softwareName Like '%Autodesk Material LIbraries 2011%'Īnd tblSoftwareUni.softwareName Like '%Autodesk Revit 2013%') As Where tblSoftwareUni.softwareName Like 'Autocad 2011%' And Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID I have found a search and tried to modify as below. They want multiple versions of Revit(13)Autodesk Material Libraries (9)and 4 versions of AutoCAD 2011 checked.Īll versions of 3 different apps, in one query. (Did a term of SQL and can't remember much) The company I work for are currently using Lansweeper and have asked me to create a SQL query to search for 3 different types of software and all versions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |