NOT EXISTS clause not working properly
769590Jun 24 2010 — edited Jun 24 2010Hi,
I have to update a table based on absence of a value in another table, I am using not exists clause but I am not getting right results -
The situation is like this -
SELECT 7092 AS dim_ky
FROM DUAL
WHERE not EXISTS (SELECT 3034 AS insm_dim_ky
FROM DUAL);
The above query does not return any records where as my understanding is that it should.
Can any one explain?