Joins in Oracle (SQL) Explained in detail with practical examples

[@tariqshakeel4289]

very well explained. Highly appreciated !!!

[@TechCoach]

Thanks Tariq :)

[@surajpatil3579]

Superbly explained

[@TechCoach]

Thanks Suraj :)

[@sravanthim965]

Very clear. Thank you!!

[@TechCoach]

I am glad I could help :)

[@chandudevarapu1578]

It's great explanation... Plz make videos on sub queries

[@TechCoach]

Thanks chandu, this video may help :)
ruclips.net/video/QaRVoXOyob8/видео.html

[@TechCoach]

@chandu,
please consider subscribing to my new channel it will really help me
ruclips.net/video/6G1xGi-D5ow/видео.html

[@roastytoasty8815]

THANK YOU!!!!!!

[@TechCoach]

I am glad I could help :)

[@prasadkulkarni7066]

Understood now ...how joins works❤

[@ChaahaChills]

Very well explained 😍😍

[@TechCoach]

@ooha thanks for the kind words.
Please consider subscribing to my other channel as well. It will really help me.
ruclips.net/video/6G1xGi-D5ow/видео.html

[@sabhijith1586]

Greate examples can you suggest me any course to in udemy to learn advanced SQL and ETL process

[@TechCoach]

I am glad I could help

[@sabhijith1586]

@@TechCoach please tell me your email to contact you

[@TechCoach]

@@sabhijith1586 [e-mail]

[@sakshijindal15]

Hey , can you make a video explaining Nested Loop Joins and Hash Joins

[@TechCoach]

Sure Sakshi, I will work on it soon.
I have a small request I am working on this new youtube channel "An Indian Abroad" ,it will really help me if you watch and subscribe to it.
ruclips.net/video/HBQHekM1U2c/видео.html

[@g2soft108]

request you to uplaod relationship video like one-to-one , one-to-many as well.

[@TechCoach]

Sure I will work on it next :)

[@ruchitrivedi7841]

Well explained!! Good job Vivek :)

[@TechCoach]

Thanks Ruchi for the kind words :)

[@shivashankar4202]

Hi !!! I have a coupe of question
1)If you want to join the any two or more tables,It should be defined PK and FK between the
tables.I mean in join condition we can specify the key columns right
2)I want to fetch the only data from first table or second table,What is the query? I mean Tbl1(1,A; 2,B; 3,C) and Tbl2(1,A; 2,B; 4,D) (both tables dont have PK and FK relation).So my reqmnt is that I wan to fetch the only Tbl1 values or Tbl2 values by us using JOIN....Thanks in advnc

[@VINOTHKUMAR-vw5kp]

why we need right join..we have left join..if i need all the rows from right side tables then i can interchange table from left to right?..

[@TechCoach]

Usually people use left , I have rarely used right myself.

[@ferosnoor4366]

where is the previous video of joins because I can't find.please give in description

[@TechCoach]

Is there anything you want me to clarify, Unfortunately I don't have any other video on joins

[@vishwanathtippe1720]

well explained

[@TechCoach]

Thanks buddy for the kind words, please consider subscribing to my other channel as well it will really help me :)
ruclips.net/video/gTg6nCUuYO8/видео.html

[@manideepkumar959]

Nice but what about self joins expected that one

[@g2soft108]

kindly explain self join as weel

[@TechCoach]

Sure I will work on it :)

[@nagarjunareddy554]

Thank you sir

[@lgtvsmart4078]

Dude, you need focus on joins not in explaining insurance business which most will be aware. Good work btw

[@TechCoach]

Thanks for the feedback I will work on it :).
I would really appreciate if you help me in my new Initiative "An Indian Abroad"
by subscribing viewing and sharing.
ruclips.net/user/AnIndianAbroadd

[@jakem5476]

Actually I'm glad he explained it a little.

[@AB-bb5cz]

Not upto the mark...use where clause please

[@itreportcambodia8283]

Hello B

[@TechCoach]

Hello