Skip to Content
0
Jun 23, 2020 at 07:57 PM

ELSE part not executing in SQL

26 Views

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?