Need to perform a JOIN statement. I want to implement a join on the results that the
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date: