HOW TO JOIN 3 OR MORE TABLES IN SQL | TWO WAYS
HTML-код
- Опубликовано: 30 сен 2024
- How to join 3 or more tables in SQL, check out the video to know!
✨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)
Can we use ANSI style for parent and child relationship
This video just saved my life, VERY WELL EXPLAINED!!! I literally spent HOURS until this. Thank you madam you are the best!
How apply where condition when joining three tables
how this saved your life? are you dying without joins??
@@Somnath-je9nd 🤣
I understood her simple paper visuals!
Bas kar bhai kitna footage khayega!
You explained it better than my professor at uni who has "years of experience"
😂
Not gonna lie, I think you explain things way better than others, I'm taking data analysis course and I struggle with the way they explain it until I watch your tutorials, thank you so much.
I totally agree with you. We have forotten the power of pen and paper
What if even we want to add condition like whose sal in less or more ,how to do it ???
finally finished my college assignment, thanks you😃
Wow i never seen a girl tutorial before , u did a great job even without pc, thx mam.
I know the 1 st method but don't know parent child relationship this method is very easy thanks 👏👏
Hi bro
How to print 4th and 9th employees details
Please also mention that in general sql writing, little advanced level....joins are fast and parent-child are not used
I prefer the second way, much easier. Thanks for the tutorial! It helped me with my assignment.
You just saved my life. Eternally grateful
Can I use it for joining two tables
yes in the 1. sql query if you dont use last two line then it will join just e and d tables
you should open a school many thenks
You simply are great in explaining things to people. Not many people have gift like you
ok so kal kiska practicals ka exam h?
hey!!! thank you so much yaar for solving my problem on join. i show so many example on join but i can’t understand that examples, but i show your example then i understand fully. and thanks again :)
That was hell of an explanation.You made the concept look so easy.
so clear explaination. Thank you...
You are welcome!
Thank youuh 🙏👌
Thank you! Very easy to understand!
Thank you so much for this video. You explained the concept in an easy way 👍.It truly helped me a lot
thank you mam.....!!!
Thank you. I managed to answer my lab because of your video.
This is a best and best ever I had seen before 🧐🧐
Hi ,Its very informative indeed but just to add that if you are showing the columns please include the common column eg. e_id to show the results as well because then u need to add table refernce with all the columns details when selecting SELECT and still the second method won't work to join the columns , if it would still join including the common columns , please let me know because that 'll open another dimension for me . Thank u so much for sharing again , it helped a lot.
It's looking for comment box after watching, it's classic to way your presentation buddy, thanks.
Brilliant. Thanks a lot dear for clearly explaining this.
The parent-child relationship is superb! Is it doable for all SQL version (MySQL, PostgreSQL, SSMS)?
best explanation ever, much better than my lecturer. two thumbs up
what if there is only id in every table how to join,i have my problem,this:Query failed: Unknown column 'p.status_id' in 'on clause'😭😭help
Absolutely brilliantly explained. Thank you
Thank you very much ma'm to sharing a wonderful video . before i was very confused . but now i got it. thank you very much.
Thnx for this wonderful video 😍😍😍😄Will the second way too do an INNER JOIN only?
gr8 very simple explanation, thank you
Thank a lot.. Such a difficult topic is explained in such a simple way..
Thank you so much for this video. You don't know how much this has helped me
is that 2nd method is for SQL Server or Mysql ? @crack Concept could you pls help me to find it.
Awesome young girl. Really you make it rocking simple to understand. Thanks a lot
Will it also be correct to write d.d_id = dp.d_id ??
Or must you write the primary key first?? Cos d_id is a primary key in department
Is it mandate to make a relationship (foreign, primary(key)) between these tables ????
Why in Joins Only 1table is written after FROM? and not in parent chil relationship !!
Thanks for the tutorial you save my life from the deadline
Thank you so much,this is well explained, i loved that video
shit... your explanation is somehow better than my teacher
We should not use same forwign key for two tables right
Best joins explanation....thank you so much mam
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
Paper work makes the viewers to feel simple & easy to understand..good work..It helps a lot.
Amazing u explained it so easily.. thanks
If I have more than 10000 records than which querie give me fast result?
Can u please explaining the
Multiple tables and multiple joins are using write the query
Pls reply the my msg
Does parent child relationship always uses inner join ?
Can we use other join types in 2nd method.
A small query regarding the two tables:
If we want to replace the e_id with e_name in details table. How to do it
these 2ways r same?, eigther i will use 1way r eigther i will use 2way for getting joins ? both that 2ways
Very nice video....which is very very helpful in interview
This is my comment in RUclips, its very useful video thank you 🙂
i have a doubt i have 3 tables where one of each is interlinked and a customer placed multiple orders with different quantity each time so how to sum quantity of that particular customer.
can anyone help me in this please
I see that you used INNER JOIN and not a LEFT JOIN
Why is that and arent they the same?
VERY WELL NEATLY EXPLAINED
BUT CAN THIS BE DONE BY CREATE VIEW.
I WATCHED ONE OF YOUR VIDEOS RELATED TO CREATE VIEW WHERE YOU HAVE MENTIONED COMPLEX TABLES CAN BE EASILY JOINED USING CREATE VIEW STATEMENT
Easy to understand... watching dis video
i am really thankful for you 2nd method is very helpful for me
thank you helped me very quickly :)
Thank u.what is patent and what is child in 2nd approach?
The 2nd method looks much simpler.
Why do we need the 1st method?
good explanation sister, thank you.
Thank u very much I also got the concept very clear
How can I join table 1 with table 2 and table 1 with table 3?
Thank you so much.Saved my time
Hi can you teach us how to insert the employee.id and department.id into details table
How will create new table and insert the values come from two other result
Very helpful toturial , thank you
Simplicity trumps tech! A drawing, fingers and words explain what coding often masks.
THANK YOU
ooooo ab samjhaaaa thanks..................
thank u dede apne difficult concept ko 2 min me asan se samjha diya. ThankYOU SOOO MUCH>
This helped me. Such clear explanation. Thank you!
Can make a video with examples n an output?
How to do this same task in SSIS?
can you do this?
é incrivel como é sempre uma crianca indiana que salva a gente, ainda explicando em uma folha de papel kkkkkk mano eu n tanko isso
Very helpful...thank you very much
Thank you so much!! You're the best
Nice , but i was expecting the output also .
It’s very simple and direct way of explaining. Thanks
What about the duplicate records???
Your voice is so good and explanation is also clear. God bless ma
Great video! I have been using the Parent-Child relationship model for 20+ years! I did not know it had a name. Also, I never could figure out how the JOIN keyword worked in SQL, so I always avoided it. Now I understand it better from this, and your other videos. Thanks! :)
Madam your salary in sql developer ? Please reply madam
Thank you so much! Your explanation is the best I've seen so far :)
This video is literally a life saver!!!
Thank you! Such a difficult topic explained in a very simple and easy to understand way!
Thank you. you explained my big problem in simple way.
Amazing - -I was Struggling for Hours in 2021 and this has just saved me - - Thank you so much
How do I combine 4 tables from 2 different DB?
this is what i've been looking for
nice content, nice explanation, nice voice 😃
Thank you! this just saved me on an assessment.
very helpful thank you so much
THANKS MAM IAM STRUGGLE THIS JOINS👍
this video saved my life thanks alot
this was so simple and well explained!! thank you!!
cute voice and nicely expalined ... cant ask for more :D