HOW TO JOIN ON NULL VALUES IN SQL | Tricky SQL Problems | SQL Interview Questions

[@HimanshuSingh-lk2my]

Nice

[@sravankumar1767]

Superb explanation 👌 👏 👍, very nice tricky question

[@sakshinaik05]

Looking forward more SQL scenario based questions

[@koushikdey100]

Great , Simply awesome ..

[@harinadhbabu309]

Well explained 🎉

[@MusicalShorts-hn1px]

Great scenario...Please post more such problems

[@ShubhamRai06]

we can also put kind of string also i believe so that it can join easily and we dont have to think of the number is there or not.

[@anirbanbiswas7624]

any number that are not already in the rows of both the tables or any string can be given,as COALESCE() asks for any value we want to place instead of null