Hi,
Trying to find match from same lookup table
declare @lookup table(Id int, code varchar(50), description varchar(50))
insert into @lookup values(1,'UK','United Kingdom')
insert into @lookup values(2,'PS','PrivatSale')
select * from @lookup
declare @datatable table(custid int, langcode varchar(50), salecategory varchar(50))
insert into @datatable values(101,'UK','PS')
select * from @datatable
-- Expected result
Custid Country Category
101 United Kingdom, PrviateSale