UPDATE AFILE A SET OPTCOD =
IFNULL((SELECT MIN(B.NOPTCOD) FROM BFILE B
WHERE A.OPTCOD = B.IOPTCOD),' ')
to the above code I have to include two more filter conditions
AND WHERE A.CLIENT = B.ICLIENT),' ')
AND WHERE A.FUTCOD = B.IFUTCOD),' ')
But some how a lot of confusion on brackets & Im unable to get correct sql.
can some one help me ?
IFNULL((SELECT MIN(B.NOPTCOD) FROM BFILE B
WHERE A.OPTCOD = B.IOPTCOD),' ')
to the above code I have to include two more filter conditions
AND WHERE A.CLIENT = B.ICLIENT),' ')
AND WHERE A.FUTCOD = B.IFUTCOD),' ')
But some how a lot of confusion on brackets & Im unable to get correct sql.
can some one help me ?
Comment