Untitled

select Users.* , c.CountryName , Firstname +' ' + lastname as FullName   from Users  
                            inner join Countries c on c.CountryId = Users.Country
                            where 1 = 1
                            and userid in (select userid from [dbo].[BossCountryUsers] where countryid = @categoryID)
                            order by FirstName,LastName