Zlucenie s prepisom – MS SQL – Fórum – Programujte.com

I have two tables like :
first:
number      fact
    1           ADMIN
    2           MANAGER
    3           ALL RIGHTS
    4           NO RIGHTS

second:
stuff           rights
   1                  3
   2                  4

I need to get this:
 stuff                       rights
ADMIN             ALL RIGHTS
MANAGER      NO RIGHTS

How should I write code in sql?

SELECT
	  a.fact AS stuff
	, b.fact AS rights
FROM
	first AS a
	INNER JOIN second AS s ON s.stuff = a.number
	INNER JOIN first AS b ON b.number = s.rights