Something like the below

SELECT

DB1.ProjectName,

DB2.ProjectStage

FROM

Database1.dbo.Table1 DB1

INNER JOIN

Database2.dbo.Table2 DB2

ON

DB1.ProjectStageID = DB2.ProjectStageID

Without knowing your data schemas it is hard to say.