>>By adding your AND condition you automatically exclude NULL records, thus you don't get them in your result. By adding an OR condition I attempt to resolve this problem. Or you can use NVL(c_Used.Used_Quantity,0) less than 10 again in the AND condition, but I think OR should perform better.
>
>Your suggestion works. Thank you.

Glad to help.