Something like this?
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon16 As icon,
tblOperatingsystem.Caption As OS,
tblOperatingsystem.ServicePackMajorVersion As SP,
tblQuickFixEngineering.InstalledOn,
tblQuickFixEngineering.Lastchanged,
tblQuickFixEngineeringUni.Description,
tblQuickFixEngineeringUni.FixComments,
tblQuickFixEngineeringUni.HotFixID,
tblQuickFixEngineeringUni.ServicePackInEffect,
TsysLastscan.Lasttime As [Last Scan For Updates]
From tblAssets
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblQuickFixEngineering On tblAssets.AssetID =
tblQuickFixEngineering.AssetID
Inner Join tblQuickFixEngineeringUni On tblQuickFixEngineeringUni.QFEID =
tblQuickFixEngineering.QFEID
Inner Join TsysLastscan On tblAssets.AssetID = TsysLastscan.AssetID
Inner Join TsysWaittime On TsysWaittime.CFGCode = TsysLastscan.CFGcode
Where tblQuickFixEngineering.Lastchanged > GetDate() - 30 And
TsysWaittime.CFGname = 'quickfix'
Order By tblAssets.AssetName,
tblQuickFixEngineeringUni.Description