SELECT Ino, bCode ;
FROM Stock_Status ;
WHERE ALLTRIM(UPPER(INO)) = "012" AND ALLTRIM(UPPER(BCODE)) = "AW" AND ;
        ALLTRIM(UPPER(LOCCODE)) == "KL" ;
GROUP BY INO,BCODE ;
INTO CURSOR csrResult



SYS(3054) show this query run with full optimized.

Thnak you

I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...