Tray Logic Mapping

select ProductRecognitionConfigurationId,A.LocationGroupDefinitionId OGD_ID,Name OGD_Name,RecognizedProductID,B.SKU,B.Product,ProductToReplaceID,C.SKU,C.Product,SceneTypeIds,D.SceneTypeName,
SubSceneTypeIDs ProgramItem_SubSceneTypeID,E.SceneTypeCategory ProgramItem_SceneTypeCategory,E.SceneTypeName ProgramItem_SceneTypeName
from ProductRecognitionConfiguration A
join product B on A.RecognizedProductID=B.ProductID
join product C on A.ProductToReplaceID=C.ProductID
join SceneType D on A.SceneTypeIds=D.SceneTypeID
full outer join vwprogramitemsubscenelist E on E.SubSceneTypeId=A.SubSceneTypeIDs
join LocationGroupDefinition F on A.LocationGroupDefinitionId=F.LocationGroupDefinitionId
where A.clientid = 77

--------------------------------------------------