hi,

thanks for the reply first of all...

i have to group by all the columns such as CompanyName, CompanyContactNumber etc., except the DB_Name where more than one company can have...