Six years after you posted this video and it is still helping people. Thank you for taking the time to create this video. I have been struggling with this concept and this finally allowed me to pull exactly what I needed.
I have a doubt. I have table with two fields, one field is array in table 1 uID | Contact 2 | 1221,1223 3 | 1123 Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2
You said that the old way is less efficient (slower) than using the JOIN function. Do you have a comment as to why this is? And also, the theoretical and actual difference in performance? Btw, great videos.
Kson Whoops. explain shows that the query evaluation plan is identical for the two. I stand corrected; they look to be equivalent. And a quick benchmarking shows equivalent performance. I guess I assumed since the WHERE join is older (ANSI-89) it is inferior performance-wise. Not so, apparently. Sorry about that. I do think, however, that the JOIN syntax improves readability/maintainability because it makes joining distinct from filtering. Easier to keep things consistent inner vs outer join too. Thanks for asking.
Brian Finnegan Thank you. That clarified it for me :) I realise it has been some time since you released these videos, but if you ever make another one, a video about outer and inner joins would be great!
You can use the up and down arrows to scroll through all of your previous statements. You can also literally copy and paste in PuTTY (and, presumably other SSH clients). In PuTTY, to copy just click and drag your mouse to highlight what you want copied. It is automatically added to the clipboard. Then to paste, just right click.
Please I have a few questions which I need help with. For these I have the tables ready but I am not sure if my queries are right. All the tables that I need are in section 1 which are done and completed. But for the queries from these tables are so confusing. I want to show you what I have done could you please show me if they are right . Please reply me if you can help me. I will send you all the queries I have done in the morning if you are ready to help me. Thank you God bless you. Kind regards Arslan
Six years after you posted this video and it is still helping people. Thank you for taking the time to create this video. I have been struggling with this concept and this finally allowed me to pull exactly what I needed.
Oh good god you are my hero. I have been looking for a solution to my ineptness for a good 6 hours now. You are a beautiful human being.
I live to serve.
Good explanation and I got exactly what i needed that is multiple ways of joining multiple tables
your way of joining is way easier. thank you so much !!
thank you..I have been looking for a video like this which can clarify everything related to joining. well your video help me here in India too.. :-)
Wonderful, so clear..!
nice example. thanks alot sir, the way you explained it, will help to many more
Thanks, great video, easy to understand and extrmely useful!
It was fantastic and useful ! thank you so much ...!!!
Great video! Thanks!
Great video! It`s helps me a lot, thanks :)
This video is getting some age on it but it is still very useful. Thanks!
Thankyou sir i really got the answer to my question
Hey man! just thank you❤️
thanku bro..really helpfull for me.
thanks alot
I have a doubt. I have table with two fields, one field is array in table 1
uID | Contact
2 | 1221,1223
3 | 1123
Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2
You said that the old way is less efficient (slower) than using the JOIN function. Do you have a comment as to why this is? And also, the theoretical and actual difference in performance?
Btw, great videos.
Kson Whoops. explain shows that the query evaluation plan is identical for the two. I stand corrected; they look to be equivalent. And a quick benchmarking shows equivalent performance. I guess I assumed since the WHERE join is older (ANSI-89) it is inferior performance-wise. Not so, apparently. Sorry about that. I do think, however, that the JOIN syntax improves readability/maintainability because it makes joining distinct from filtering. Easier to keep things consistent inner vs outer join too. Thanks for asking.
Brian Finnegan Thank you. That clarified it for me :) I realise it has been some time since you released these videos, but if you ever make another one, a video about outer and inner joins would be great!
KobleOza Good idea. I've been meaning to do that one for a while and now have added an inner vs. outer video: ruclips.net/video/RpWcN7GosfE/видео.html
Brian Finnegan Another idea would be a video that clearly seperate the GROUP BY and ORDER BY-functions. Thank you so much for these videos!
how do u paste the previous copy as u did?
You can use the up and down arrows to scroll through all of your previous statements. You can also literally copy and paste in PuTTY (and, presumably other SSH clients). In PuTTY, to copy just click and drag your mouse to highlight what you want copied. It is automatically added to the clipboard. Then to paste, just right click.
यह तो एक उदाहरण के लिये दिये है
इसी तरह से अलग अलग परिवारो के अगर हजारों लिखने हो तो कैसे होगा
Good video. Terrible soul patch.
Please I have a few questions which I need help with.
For these I have the tables ready but I am not sure if my queries are right. All the tables that I need are in section 1 which are done and completed. But for the queries from these tables are so confusing. I want to show you what I have done could you please show me if they are right . Please reply me if you can help me. I will send you all the queries I have done in the morning if you are ready to help me. Thank you
God bless you.
Kind regards
Arslan