select case A.ItemCode when isnull(A.ItemCode,null) then A.ItemCode else B.ItemCode end as 'ItemCode' ,case A.ItemName when isnull(A.ItemName,null) then A.ItemName else B.ItemName end as 'ItemName' ,B.PlannedQty as Planned,B.CmpltQty as Completed, A.OnHand, A.MinLevel as Min, A.MaxLevel as Max,A.MinOrder as Reorder,B.DocNum from (
(SELECT T0.ItemCode, T0.ItemName, T1.OnHand, T0.MinLevel , T0.MaxLevel ,T1.MinOrder
FROM dbo.OITM AS T0 left outer JOIN
dbo.OITW AS T1 ON T0.ItemCode = T1.ItemCode
WHERE (T1.WhsCode = 'SIP') AND (T1.MinOrder >= T1.OnHand )and MaxLevel<>0 )A
full outer join (select T0.DocNum,T0.ItemCode,T1.ItemName,T0.PlannedQty,T0.CmpltQty from OWOR T0 inner join OITM T1 on T0.ItemCode=T1.ItemCode where (T0.Series=411) and T0.status<>'C' and T0.status<>'L') B on
A.ItemCode=B.ItemCode
)