select

a.code

, aname

, bname

, cname

from (

select

code

, bName

, ROW_NUMBER() over (partition by code order by code) as br

from @b-2

) b

right join (

select

code

, cname

, ROW_NUMBER() over (partition by code order by...