Untitled

mail@pastecode.io avatar
unknown
plain_text
2 years ago
385 B
4
Indexable
Never
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