Hi,
I have created an query which should give me a result.
Problem that i have is when there is NO data on OSCN fior the specific ItemCode then they query does not give me a result. I then would actually see the result T0.SalPackMsr.
This is the query:
SELECT
CASE
WHEN (T1.U_custpack <> NULL or T1.U_custpack <> ' ')
THEN T1.U_custpack
ELSE T0.SalPackMsr
END
FROM OITM T0
RIGHT OUTER JOIN OSCN T1 ON T0.ItemCode = T1.ItemCode
Where T0.CardCode = $[$4.0.0] AND T1.ItemCode = $[$38.1.0]
Kind Regards
Mark