Need to perform a JOIN statement. I want to implement a join on the results that the select statement returns the table called "MET_REF" in a database. I have the table made, what is needed is to make correction to the query statement below

select @initial as REF_SERVICE_ORDER_KEY, @referkey as MAINTENANCE_ORDER_KEY, @OGORDER as OG_MAINTENANCE_ORDER_KEY, CREATED_ON

from TEMP_MAIN_project a

LEFT JOIN MET_REF b ON @OGORDER = b.CREATED

where MAINTENANCE_ORDER_KEY = @referkey

Fix the query above (you can have an example but has to be similar to this above in order for it to work)