Can anyone help please?

Thanks

Darren

SELECT productType.COMPONENTTYPENAME "Product Type",resource.RESOURCENAME "Asset Name",product.COMPONENTNAME "Product",productType.COMPONENTTYPENAME "Product Type",aao.NAME "Vendor Name",state.DISPLAYSTATE "Asset State",rtype.TYPE "Asset Type",rCategory.CATEGORY "Asset Category",resource.SERIALNO "Serial Number",deptDef.DEPTNAME "Department",regionDef.REGIONNAME "Region",aaov.NAME "Site" FROM Resources resource LEFT JOIN ComponentDefinition product ON resource.COMPONENTID=product.COMPONENTID LEFT JOIN ComponentType productType ON product.COMPONENTTYPEID=productType.COMPONENTTYPEID LEFT JOIN ResourceType rtype ON productType.RESOURCETYPEID=rtype.RESOURCETYPEID LEFT JOIN ResourceCategory rCategory ON productType.RESOURCECATEGORYID=rCategory.RESOURCECATEGORYID LEFT JOIN VendorDefinition resourceVendor ON resource.VENDORID=resourceVendor.VENDORID LEFT JOIN SDOrganization aao ON resourceVendor.VENDORID=aao.ORG_ID LEFT JOIN ResourceState state ON resource.RESOURCESTATEID=state.RESOURCESTATEID LEFT JOIN ResourceOwner rOwner ON resource.RESOURCEID=rOwner.RESOURCEID LEFT JOIN ResourceAssociation rToAsset ON rOwner.RESOURCEOWNERID=rToAsset.RESOURCEOWNERID LEFT JOIN DepartmentDefinition deptDef ON rOwner.DEPTID=deptDef.DEPTID LEFT JOIN ResourceLocation resLocation ON resource.RESOURCEID=resLocation.RESOURCEID LEFT JOIN SiteDefinition siteDef ON resLocation.SITEID=siteDef.SITEID LEFT JOIN SDOrganization aaov ON siteDef.SITEID=aaov.ORG_ID LEFT JOIN RegionDefinition regionDef ON resLocation.REGIONID=regionDef.REGIONID WHERE  (state.DISPLAYSTATE = 'Disposed')   GROUP BY resource.RESOURCEID ORDER BY 1