Windows based program getting error from sql server

I got the solution. 

 

select *,l.name as Divname from DB_PL_SETUP.dbo.tbl_profile p inner join tbl_Location l on p.location collate SQL_Latin1_General_CP1_CI_AS =l.loccd where p.uid='admin' 

hi

please read this articale 

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/01671529-337a-474b-89d3-dc1fb21d641f/how-to-fix-an-errorquotcannot-resolve-the-collation-conflict-between?forum=transactsql