select [PSCStest].[dbo].[PSC3300_T_SYTELINE_JOB_MASTER].MFG_NO , [PSCStest].[dbo].[PSC3300_T_SYTELINE_JOB_MASTER].DESCRIPTION , [PSCStest].[dbo].[PSC3300_T_SYTELINE_JOB_MASTER].ITEM_CODE
from [PSCStest].[dbo].[PSC3300_T_SYTELINE_JOB_MASTER]
left join [PSCStest].[dbo].[PSC2210_T_MOVE_LOCATION]
on [PSCStest].[dbo].[PSC2210_T_MOVE_LOCATION].HEAT_NO = [PSCStest].[dbo].[PSC3300_T_SYTELINE_JOB_MASTER].HEAT_NO