How to I merge multiple rows of data from the same table with the same ID. I have tried group by by I get the following error Column 'cos_attribute.bunit' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
The running this query
provides a result of
AssetID bunit system_type priority
14 Personnel Services NULL NULL
14 NULL Printer NULL
14 NULL NULL Low
What I would like to see is
AssetID bunit system_type priority
14 Personnel Services Printer Low
The running this query
SQL:
select * FROM cos_attribute WHERE AssetID = 14
AssetID bunit system_type priority
14 Personnel Services NULL NULL
14 NULL Printer NULL
14 NULL NULL Low
What I would like to see is
AssetID bunit system_type priority
14 Personnel Services Printer Low