Sometimes we don’t realise the beauty of something we created until someone recognises it.
Maybe we are too humble to acknowledge our work is as good as someone else’s, or maybe we don’t have enough confidence to take pride in something we created.
I don’t know why!
PS: These paintings were done by my wife, and yet she still believes she can’t draw.
Let me know your comments on the above. Thank you!
I am the wizard
who can make you dream,
fall in love,
dance in the rain,
find peace,
and enlighten you.
Yes, I am a poet.
നിങ്ങൾ മതങ്ങളിലേക്ക്
ചുരുങ്ങി മരിക്കുമ്പോൾ,
ഞങ്ങൾ മനുഷ്യരിലേക്ക്
പടർന്ന് അമരന്മാരാകും.
സമരസൂര്യൻ
അസ്തമച്ചോപ്പിൽ
അലിയുമ്പോൾ,
അയാൾ ഉയർത്തിയ
ആശയത്തിന് കീഴെ
നാമിനിയും പോരാട്ടം
തുടരും.
SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
)
When I ran the above query I know the condition will give me the results, because the data exists in the TABLE1 which is not in TABLE2. But I didn’t go any results. I got surprised. After I a while I found out the issue.
So the reason is that ID column in the TABLE2 have null values. If any value of ID in the subquery is NULL, then the entire NOT IN clause fails to match anything. This is standard SQL behavior because NULL makes the whole comparison unknown.
Solution:
NOT NULL condition in the sub-query as below:SELECT *
FROM TABLE1
WHERE ID NOT IN (
SELECT ID
FROM TABLE2
WHERE ID IS NOT NULL
)
NOT EXISTS:SELECT *
FROM TABLE1 T1
WHERE NOT EXISTS (
SELECT 1
FROM TABLE2 T2
WHERE T1.ID = T2.ID
)
The NOT EXISTS will automatically handle null values and safer to use.
Until next time, good bye Georgia! Thank you for filling my hands with memories and my heart with love and kindness. ♥️🇬🇪
When the mountain smiles and the wind whispers to you, you’ll know you’re a mountain person.
Don’t wake me, I’m not dreaming. 🇬🇪 🌉
