Lec-41: Equi Join operation with Example | Database Management System

Equijoin is a classified type of inner join that returns output by performing joining operations from two tables based on the common column that exists in them. This join returns only those data that are available in both tables based on the common primary field name.

►Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

#EquiJoin #SQlDBMS #FreeEducationGATE

[yashmishra]

Poor Ravi hasn’t got a Dept for the last three lectures.

[vasuudayar]

Thank you very much sir now i got a confidence to solve join queries.

[yogeshjadhavybj]

Sir, Your Explanation is Top Notch.. Anyone can understand with The Simple Language... Thank u So Much sir... Now My Concept of DBMS is crisped.. and clear.

[sashnika]

You are the best teacher so far for computers ❤️💯bcoz of your clear cut to cut explanations and clarity of concepts..anyone can fall in love with computer science🙏🙏great Sir you are too good.God bless you🙂I have an interview for a company ..so referring your videos for dbms revision👍🙏

[firefighter]

use SELECT DISTINCT instead of using just SELECT to avoid duplicate entries in the answer.

[shwetasharma]

All prayers with you.. God bless you forever

[rjmathguru]

Thank u sir your lesson is so helpful to me at the time exam

[adeitykaushik]

Thank you sir ji
A lot of respect 🙏🙏

[vasudevtiwari]

how to avoid the cross product from happening as it takes huge amount of memory ?

[bilgetonyukuk]

I am Turkish and I didn´t understand many of your words, except the English ones, but nevertheless I understood the concept very well. Thanks!

[ishanpandy]

query :
select teacher_name from world_teachers where teaching_style = 'BEST';
output:
Varun sir

[tabassumkadeeja]

Why don’t we have teachers like him 😭 thank you ☺️

[batman]

i am your fan sir.. so easily you have explained.. 5000 karch kiya bangalore mein sql sikhne mein.. ap ki video miljati tu paise bachjate

[talhaamir]

It's 2020 and he's still the best !!!

[ganeshkanade]

Apke lectures dekhkar pura DBMS ek din main sikh sakta hai koi bhi ... Thanks for making such a beautiful lecture series.

[binodthakur]

i was struggling then i find your videos really loved continuing and can't stop my self for thanks.Great sir.Hope you after covering these you have made database schema on job_portal_database, ecommerce_database or any simple school_teacher_database.

[AbdulAhad-lmnp]

I wish I found your channel earlier, nevertheless great teaching style sir.

[sampathiraosaiganesh]

Can we write
Select E-name from emp natural join dept where emp.adress = dept.location ?
As when we write natural join, there is no need write the condition :- Emp.no = Dept.e_no

[Ubaid-bk]

Mai Pakistan sy Azad Kashmir sy hon ....ma sry semester ma Sirf Ap ki videos dkhte hon ...Jo easily Mera paper b ho jta ha bht achy or easy concept dety ....ap mery India sy best teacher Ap sy bht Kuch sikha ha ....Mai just apni study k related ap k lecture hi dkhte hon ...thank you sir ❤

[Gamingboy-wvlh]

Hello sir i m an 👽 alien and i didnt understand your words except english and hindi. Thanks for such a great video from another planet 🙏. Jai hind