JOINS IN SQL (with example )

Рет қаралды 601,742

5 жыл бұрын

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/sadia1702

Пікірлер: 260

@crackconcepts 10 ай бұрын

✨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)

@hachinyesom1343 2 жыл бұрын

you just gained a subscriber, been having difficulties understanding the JOIN CLAUSE , Thank you

@hemanths5570 4 жыл бұрын

Voice...👌 Concept...👌👌

@rsarveshr5773 21 күн бұрын

Lesson learned ...👌 Hitting on the girl...👌👌

@Abhishek-Khelge 4 жыл бұрын

this few mins videos cleared all doubt, thank you

@paulanirban8888 2 жыл бұрын

Thanks for explaining it in such a simplified manner. This is really helpful.

@harshasatya2597 Жыл бұрын

i came all the way from w3 schools to understand join operation and i find the right one thanks a lot...

@ujjwalbhardwaj5595 3 жыл бұрын

Nicely and briefly explained ! type of video i was looking for ! Thanks

@hiranyeypriya2178 4 жыл бұрын

simple and well explained example! thanks!!

@AshishKumar-px3tj 3 жыл бұрын

Thank you so much for clearing all doubt😊

@codesnack3606 3 жыл бұрын

Easy, Short And comprehensive explanation....on point

@madhuri.t494 3 жыл бұрын

crisp and clear 👍good work!

@richiereji 4 жыл бұрын

Great explanation!! The concepts were easy to understand for a beginner like me.

@chandu4764 2 жыл бұрын

Bro.. did you have learned plsql now.. If yes.. suggest me utube channel bro plz

@neighmashele Жыл бұрын

you are a blessing!! thank you very much for this channel

@ManvendraSingh-xh2ry 2 жыл бұрын

Very very simple and crisp explanation... Wish I can understand everything like this

@technicalknowledge5678 3 жыл бұрын

Thankyou for making these videos 🔥.. good for interview preparation 👍

@rahulmistri1997 3 жыл бұрын

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.

@majjigapuridhisrireddy4682 2 жыл бұрын

Got a good clarity on joins after watching this video, thank you

@Infanuu 3 жыл бұрын

sizzy yuh deserve for oll lyfz❤️ worth oll lectures🔥🎉

@prathameshpendal6899 3 жыл бұрын

Great explaination... Easily understood Thank you so much

@sameerchhetri6757 2 жыл бұрын

Amazing work the way you told is excellent !!!

@williamsantosh5803 3 жыл бұрын

Thanks for the short and clear explanation on this topic.

@afzalahmad9015 3 жыл бұрын

her voice is so soothing well explained

@chinnichinni7055 2 жыл бұрын

I guess she is singer too

@rahulx9a 2 жыл бұрын

Great explanation, easy to follow for beginners

@nareshnaidu8759 4 жыл бұрын

U r givining clear explanation I will easily understood

@rakshitah8419 2 жыл бұрын

Thank you so much.. Clearly explained, and your voice is soothing

@sanigopichand1928 3 жыл бұрын

Super explanation. I watched many videos to understand this topic . U nailed it .Tq 😘

@nitus4411 3 жыл бұрын

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...!

@pranavgambhirrao8574 4 жыл бұрын

Nice explanation. & Please create a video on Indexes and Normalisation in SQL. Thank you🙂

@jdsagar7547 4 ай бұрын

Thank you , its so simple and clear

@badrisudha8922 2 жыл бұрын

I love your way of teaching with deep explanation sister... thank you so much

@naveenchowdary7098 4 жыл бұрын

Thank you for ur nice explanation 👍

@prathishbysani5749 2 жыл бұрын

can we perform operation like left join on 2 tables each table consists single column?

@techninja9461 3 жыл бұрын

Excellent Explanation. amazing and soothing voice.✨✨✨✨. keep making these kind of videos , really helpful.💖

@pavanipinnaka8338 2 жыл бұрын

Brillient explanation. I understood the concept now. Thankyou.

@mallireddy8721 2 жыл бұрын

thanks mam, easy understanding and perfect examples.

@MdSameer-df3xj 5 ай бұрын

A good example of a table....great explanation

@gouravm4986 4 жыл бұрын

Thank you mam💞 saved my practical viva

@sheetalmendgudli6795 3 жыл бұрын

Very nice explaination.... anyone can understand easily by watching your video.... thank you

@ajitbhalerao164 3 жыл бұрын

Wow this explanation is one of the best!!

@varunsharma2507 3 жыл бұрын

You have a lovely voice...and thnx for clearing my doubts!💫🙇💐

@divymeher5239 3 жыл бұрын

This was a great video Keep making such videos Subscribed👍👍

@ayushikarn1893 3 жыл бұрын

The real catch is when there are repeated values in one or many table.. great explanation

@meditationmantras...3372 2 жыл бұрын

All possible combinations will get print

@ukeshwaran2666 3 жыл бұрын

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

@reetuchoudhary890 Жыл бұрын

U made it so simple. Thanks

@beharakanna 3 жыл бұрын

Can you please show the demo on the system...

@rohitsailas4028 2 жыл бұрын

Thank you for a clear and concise explanation

@pallavihs6904 2 жыл бұрын

Good and simple u made it easy for us to understand well time saving ✌️

@suryas8407 7 ай бұрын

Thank you for explaining very clearly.

@aayushisoni4009 3 жыл бұрын

can you please make a video over other joins like theta join , equijoin, cross and natural join

@everydaysports6431 4 жыл бұрын

Really helpful Thank you

@indianvloggerswara7669 3 жыл бұрын

Very nice explanation for the beginner 👍

@shakiraafshan6544 3 жыл бұрын

hi sadiya, what is the difference between equi join and inner join? plz reply

@abhishekyadav7073 3 жыл бұрын

Aaaaaaall the concept best explained🔥

@keertig8932 2 жыл бұрын

Great explanation for beginner to lean sql.please share vedios for how to learn complex queries.

@adityarastogi3483 2 жыл бұрын

Thanks a lot ! it really helped..keep it up :)

@sricharanreddy3913 4 жыл бұрын

can you please tell me how will we know to use which join at what point

@hemantbhatt1486 3 жыл бұрын

Very good explanation !!! Thank you

@gowrig9742 3 жыл бұрын

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..

@ashokbhum06 Жыл бұрын

Hi.. great video...can we request for a example with blank values

@Umairkhan-ou3rd 7 ай бұрын

One Question is that how to determined which table side right table or Left table.

@geoafrikana 3 жыл бұрын

Nice video. Clarified the concept. I won't say a thing about the voice.🤗

@vaishnavis9473 2 жыл бұрын

Huge thanks to you ❤

@amanbhargava2702 2 жыл бұрын

Thank you Sadia

@vaibhavjagtap2509 3 жыл бұрын

Ty so much great work👍👍

@govardhanindian 4 жыл бұрын

Mam , can you give syntax for more than 2 tables of full outer join.

@shravankatta4171 3 жыл бұрын

can not write like "Select Name From Tablename where EmployeeId = ManagerID" insted of self join

@hemanathrajendran7581 4 жыл бұрын

You gave us simple explanation on joins , thank you so much :)

@u.r.9706 3 жыл бұрын

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?

@k.h.6991 3 жыл бұрын

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).

@mohon145 3 жыл бұрын

How can I determine which one is the left table and right table?

@himanshusoni9035 3 жыл бұрын

Table on left while using join keyword is left and right to join keyword is right

@mdhelal7061 2 жыл бұрын

Sweet voice along with good explanation..............

@flameyt3721 Жыл бұрын

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

@manishasdiary5234 2 жыл бұрын

Thank you so much

@devih5558 3 жыл бұрын

Well explained, thank you.

@abhishekv8093 Жыл бұрын

Super. Oh god I saw lot of videos but ur explanation helped me understand the concept. 🙏🙏

@suriyakalai7352 3 жыл бұрын

Well explained£thank u so much🤩🤩🤩🤩🤩🤩

@labhibhati5554 3 жыл бұрын

In self join example, name will be printed ryt?? Or emp_id?

@sneha7043 3 жыл бұрын

How will be the output table looks in self join? Pls answer this question

@Karthik-dk6ln 3 жыл бұрын

Thanks mam for your nice explanation 👍

@laxmikambar7610 2 ай бұрын

Thanks for the information

@lateshpatil9262 2 жыл бұрын

every thinks great explained but self join wherever write a code that time no used inner join word that replace self join

@Crazyanya_ Жыл бұрын

thank you so much after watching to many videos i find perfect one nice explanation in practical way

@paramvirsohi5922 2 жыл бұрын

Best explanation with simple table

@adityanaidu9388 3 жыл бұрын

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

@satheeshchandran5773 3 жыл бұрын

Can you explain about left outer join and right outer join?

@arvindraja9069 Ай бұрын

Mam I have doubt that is If order table is used before 'on' clause what will happen mam?

@priyankadevarapalli7295 4 жыл бұрын

"why is it not mentioned as self join in self join and mentioned as inner join?"

@geoafrikana 3 жыл бұрын

Seems it's a slip of tongue

@chinnichinni7055 2 жыл бұрын

How to get the details of first table which are not available in second table

@manikhantayema2395 2 жыл бұрын

I thnk u can use except command.i also dnt I thnk just

@jung-kookbunnie3762 3 жыл бұрын

Great explanation ThankU 👍

@pratikkulkarni4929 2 жыл бұрын

Thank you sadiya superb explanation 👏👏💐💐

@kumaraveeravenkataganeshpi7188 2 жыл бұрын

Super explanation tqqq ...

@erumfatima179 2 жыл бұрын

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

@aktech9006 3 жыл бұрын

Great video helped me a lot tysm

@acadroit 3 жыл бұрын

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.

@sivasu07 3 жыл бұрын

Bro just put query and practice more

@priyankadevarapalli7295 4 жыл бұрын

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.