Join table data from another Database in Same Instance in SQl Server

Passing dbname in current procedure will display join data of current database table1 data and another database of table2 data.

CREATE PROCEDURE [dbo].[JoinDataFromAnotherDB]
@dbName VARCHAR(200)
AS
DECLARE @sql VARCHAR(max)
SET @sql = ‘SELECT t1.*,t2.*
FROM table1 t1 INNER JOIN ‘+@dbName+’.dbo.table2 t2 ON t1.ID = t2.ID’
EXEC (@sql)