HI,
I am writing this query in formated search:
IF $[OITT.U_LWmm] IN (SELECT "U_LenMm" FROM OITM WHERE "ItmsGrpCod" = '100')
BEGIN
Select "ItemCode" FROM OITM WHERE "U_LenMm" = $[OITT.U_LWmm] and "ItmsGrpCod" = '100'
END
ELSE
BEGIN
Select "ItemCode" FROM OITM WHERE "U_LenMm" BETWEEN $[OITT.U_LWmm.Number] - '2' and $[OITT.U_LWmm.Number] + '2' and "ItmsGrpCod" = '100'
END
It is executing the first part accurately but it is not executing the else part in case IF condition is false. May anybody help please?