Thanks a lot, i've been struggling to graps the logic behind using one or another, especially in my class where there is that querry as example that i struggled to understand until i watched the video, it really helped me "visualize" how it works. Thanks again !
@@agermoune Hi, and thanks for asking! I'm going to start working on this channel again. Stay tuned, and let me know if you have any good video ideas that would help you!😀
@@DatabasebyDoug@DatabasebyDoug I'm looking forward to your upcoming content (already subscribed!). I'm especially interested in videos covering: Inner Join vs. Left Join: when filtering should occur (ON vs. WHERE clause). Best practices for SQL syntax and formatting: any additional tips beyond what you've already shared would be great. Advanced SQL case scenarios I'm happy to pay for your content and would love to know if you offer any Udemy or LinkedIn courses. Thanks for your excellent teaching style!
Yes, they are the same. I had to try some examples to make sure that NULL handling was the same. But you might *need* to move the NOT away from the IN to do something like WHERE NOT (CategoryID IN (1,2,3) OR another_condition)
Thanks a lot, i've been struggling to graps the logic behind using one or another, especially in my class where there is that querry as example that i struggled to understand until i watched the video, it really helped me "visualize" how it works. Thanks again !
Thanks Doug for the Not in explanation, I don’t know how only your video made me grasp the reason why we don’t get result set. Again Thank you!
Do you have any other Chanel or platform where you post more videos?
@@agermoune Hi, and thanks for asking! I'm going to start working on this channel again. Stay tuned, and let me know if you have any good video ideas that would help you!😀
@@DatabasebyDoug@DatabasebyDoug I'm looking forward to your upcoming content (already subscribed!). I'm especially interested in videos covering:
Inner Join vs. Left Join: when filtering should occur (ON vs. WHERE clause).
Best practices for SQL syntax and formatting: any additional tips beyond what you've already shared would be great.
Advanced SQL case scenarios
I'm happy to pay for your content and would love to know if you offer any Udemy or LinkedIn courses. Thanks for your excellent teaching style!
is 'NOT CategoryId IN' the same as 'CategoryId NOT IN' ? I've never seen the first option...
Yes, they are the same. I had to try some examples to make sure that NULL handling was the same. But you might *need* to move the NOT away from the IN to do something like WHERE NOT (CategoryID IN (1,2,3) OR another_condition)
I never thought about that!
great video :)
Thanks
Interesting. But what if someone uses an outer join in "not exists", then both becomes same.
I think that's exactly right.
Thanks