JOINS IN SQL (with example )
Вставка
- Опубліковано 13 жов 2024
- If you need personal help in SQL, Mock interviews, You can contact me on work.sadiasiddiqui@gmail.com, Please note it will be a paid.
✨Work related mails can be sent on:
work.sadiasiddiqui@gmail.com
✨If you appreciate my work and would like to donate to support our channel, you can do so here:
paypal.me/sadi...
✨Link to my SQL e-book: imojo.in/rkajq9
✨Link to 'Switch your career easily' e-book: imojo.in/1FL7KaG
(Perfect for anyone willing to switch to a completely new field or to a different company in the Tech World)
you just gained a subscriber, been having difficulties understanding the JOIN CLAUSE , Thank you
i came all the way from w3 schools to understand join operation and i find the right one thanks a lot...
Voice...👌 Concept...👌👌
Lesson learned ...👌 Hitting on the girl...👌👌
Even here Flirting 😏😂
this few mins videos cleared all doubt, thank you
her voice is so soothing
well explained
I guess she is singer too
Great explanation!! The concepts were easy to understand for a beginner like me.
Bro.. did you have learned plsql now..
If yes.. suggest me utube channel bro plz
Got a good clarity on joins after watching this video, thank you
Correct me if I'm wrong
Here left table is customers and right table is orders
But in explanation you have references as left table as orders and right table as customers
Left table will be table that's next to 'From' and Right will be table after 'join' clause.
The bestest explanation on internet for joins
Bestest comment on the comment box
Thanks for explaining it in such a simplified manner. This is really helpful.
Thank you so much for clearing all doubt😊
Amazing work the way you told is excellent !!!
you are a blessing!! thank you very much for this channel
Very very simple and crisp explanation... Wish I can understand everything like this
Great video and well paced . Just a suggestion after explanation do a small code walkthrough of the same concept as that would be giving the whole picture to someone who's new to the subject.
Nicely and briefly explained ! type of video i was looking for ! Thanks
Great explanations, concept is very much clearly explained.....but it would be even more helpful for beginners if u include "what will be the output or result for self join".
Hope u will add it in video next time.
Thanks in advance.
The real catch is when there are repeated values in one or many table.. great explanation
All possible combinations will get print
This video has simply cleared my all doubts which was there in my mind for past 4 years! Thankyou your efforts needed to be appreciated ...Kudos
The joins in sql were haunting me from past 3 days. I have watched many videos but none helped. Thank you so much mam for such a lucid explanation. I want to know how can I excel in SQL. I want to become a database administrator. Please guide me. And if I can contact you or your teammates. Please guide me that also.
Bro just put query and practice more
crisp and clear 👍good work!
Easy, Short And comprehensive explanation....on point
sizzy yuh deserve for oll lyfz❤️
worth oll lectures🔥🎉
A good example of a table....great explanation
U r givining clear explanation
I will easily understood
Hi, for self join SELECT E.name FROM Employee E, Employee M WHERE E.emp_id=E.manager_id; will it work same as ur example? Please explain..
I love your way of teaching with deep explanation sister... thank you so much
Your sequence of videos in playlist is not right plz make it right for easy undestanding👍
Can I donate u sis I really encourage your work
Hey. Thanks for considering. Means a lot. But it's fine 😊
Ghnta !! I mean she teaches really well but don't try to get her in conversation with you
Please do video on date functions in sql
Waah, self join is the thing where I was confused. Thanks for the video. 🙂🙂
Inner join = where their entities link (via some action - how many links = how many rows in resultant table)
Correction: in last example of self join "pqr" will be printed
Great video though👏
I think the output will be null
Thankyou for making these videos 🔥.. good for interview preparation 👍
hi, thanks for the tutorial, it was very helpful. "The last example you gave about self join in order to find out same id values, can we not simply just add a where clause stating "WHERE emp_id = manager_id" in order to retrieve the same value?
No, because an employee is usually not their own manager. You could replace the join with a subquery in where, but you'd still have to reference the same table. And I guess it would be slower (because joins are fast).
Thank you so much.. Clearly explained, and your voice is soothing
simple and well explained example! thanks!!
Thank you , its so simple and clear
How to get the details of first table which are not available in second table
I thnk u can use except command.i also dnt I thnk just
far better than edrueka sql join video.
How can I determine which one is the left table and right table?
Table on left while using join keyword is left and right to join keyword is right
Chala baga Explain chesaru MADAM, Thanks for your explanation Madam
What a great upbringing 👏
Thanks for the short and clear explanation on this topic.
can we perform operation like left join on 2 tables each table consists single column?
Natural born instructor. Thank you. Subed n liked.
Thank you for explaining very clearly.
Super explanation. I watched many videos to understand this topic . U nailed it .Tq 😘
What happens if I don't use ON Statement in this join clause?
If orders and customers have 196 and 91 in number respectively.
And if I don't use ON
I got 196*91 records.
But I cannot understand what really happens. In what logic will they combine?
Can you clear my doubt
Hi.. great video...can we request for a example with blank values
How did you know that ORDER table is left table? I can consider CUSTOMERS also as left. Also in the video left table seems for customers not the order but you are saying order is the left table, how? Please explain
Great explanation for beginner to lean sql.please share vedios for how to learn complex queries.
U made it so simple. Thanks
Excellent Explanation. amazing and soothing voice.✨✨✨✨. keep making these kind of videos , really helpful.💖
Very nice explaination.... anyone can understand easily by watching your video.... thank you
You have a lovely voice...and thnx for clearing my doubts!💫🙇💐
WHEN USING OUTER JOIN,YOU MUST EXPLICITLY STATE THAT YOU WANT EITHER A LEFT JOIN OR A LEFT JOIN IT'S TRUE OR FALSE STATEMENT PLEASE REPLY
Great explaination... Easily understood Thank you so much
Sweet voice along with good explanation..............
You gave us simple explanation on joins , thank you so much :)
every thinks great explained but self join wherever write a code that time no used inner join word that replace self join
I started following your videos. Your explanation made me easy to understand. I hope this will help me for interview questions too...Thank you so much...!
Best explanation with simple table
Thank you mam💞 saved my practical viva
thanks mam, easy understanding and perfect examples.
Thank you Sadia
hi sadiya, what is the difference between equi join and inner join? plz reply
Brillient explanation. I understood the concept now. Thankyou.
Can you please show the demo on the system...
Please make video for Procedures, Triggers, Views , functions
I have made. Please check them out 😊
why in one table in inner join cust_id and 2nd table only id ,it must be cust_id, becos one column must be common
Not necessary. Column names can be different
@@crackconcepts then on what basis they are joined, leave it mysql ,let us take two building if you want both building then they must have common thing like both are of same company somthing else common other wise what use of join
ua-cam.com/video/DObZFQ-Q5FQ/v-deo.html
Superb explanation, keep it up for more concepts.
thank you so much after watching to many videos i find perfect one nice explanation in practical way
Wow this explanation is one of the best!!
Thank you
Nice explanation. & Please create a video on Indexes and Normalisation in SQL. Thank you🙂
Super. Oh god I saw lot of videos but ur explanation helped me understand the concept. 🙏🙏
Thank you for ur nice explanation 👍
One Question is that how to determined which table side right table or Left table.
In self join example, name will be printed ryt??
Or emp_id?
Why designation and amount is not included in the output table?
Because in select query it doesn't have those column's names
Mam I have doubt that is If order table is used before 'on' clause what will happen mam?
Great explanation, easy to follow for beginners
can you please make a video over other joins like theta join , equijoin, cross and natural join
Thank you for a clear and concise explanation
This was a great video
Keep making such videos
Subscribed👍👍
It clears my everything related to SQL 😭 u r great❤
Glad it helped!
How will be the output table looks in self join? Pls answer this question
Thanks a lot ! it really helped..keep it up :)
can not write like "Select Name From Tablename where EmployeeId = ManagerID" insted of self join
very good simple explanation
Nice video. Clarified the concept. I won't say a thing about the voice.🤗
Good explanation I never see this type explanation keep it up
Huge thanks to you ❤
Mam , can you give syntax for more than 2 tables of full outer join.
Very nice explanation for the beginner 👍
Your voice makes understanding concepts easier 😍. Thank you Mam.
natural join?
Thank you sadiya superb explanation 👏👏💐💐
can you please tell me how will we know to use which join at what point
"why is it not mentioned as self join in self join and mentioned as inner join?"
Seems it's a slip of tongue