Guntur K wrote:Chances are, they are both working. Sometimes "no rows found" is the right answer.
I have two SQL command, first command doesn't work (provide no record found) but the second one is working.
I don't know why.Whenever you have a question, please post CREATE TABLE and INSERT statements for a little sample data, so the people who want to help you can re-create the problem.
Any body can help me to explain.
Command (1)One possible explanation is that v_doc_tb_po_req1_x.row_id is sometimes NULL. NOT IN won't be TRUE if the sub-query returns NULLs.
row_id_doc is not null and
row_id_doc not in(select row_id from v_doc_tb_po_req1_x);