i work on sql server 2014 i need to get categories c and x without using self join
but i don't know how to make that
my data sample
create table #category
(
categoryc int,
categoryx int
)
insert into #category(categoryc,categoryx)
values
(19,20),
(50,75),
(80,70)
create table #categorydetails
(
categoryid int,
categoryname nvarchar(300)
)
insert into #categorydetails(categoryid,categoryname)
values
(19,'bmw'),
(20,'mercedees'),
(50,'feat'),
(75,'toyota'),
(80,'mazda'),
(70,'suzoky')
select d1.categoryname as categoryc,d2.categoryname as categoryx from #category c
left join #categorydetails d1 on d1.categoryid=c.categoryc
left join #categorydetails d2 on d2.categoryid=c.categoryx
so how to get data above without using self join
are there are another way to do that without using self join
expected result
categoryc |
categoryx |
bmw |
mercedees |
feat |
toyota |
mazda |
suzoky |