The biggest difference between an INNER JOIN and an OUTER JOIN is that the inner join will keep only the information from both tables that's related to each other (in the resulting table). An Outer Join, on the other hand, will also keep information that is not related to the other table in the resulting table.
There are three types of joins in SQL: Inner Joins, Outer Joins, and Cross Joins:
Inner joins return all the rows from both tables that have matching values in their corresponding columns. For example, if we have a table with city names and another table with country names, an inner join would return all the rows from both tables where the city name is equal to the country name.
Outer joins return all the rows from one table that exist in the other table - for example, if we have a table of cities and another table of countries. An outer join would return all the cities that exist in any country.
Cross joins (JOIN) return all rows from one or more tables
All good , but provide the data also for the assignment , Without data the interest is less day by day from the course. So, try to solve this problem as asap.
Everything is good but keyboard sounds more harsh and overlap your voice whereas this course is best.
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file.
In SQL Join Function's 2nd video - Teacher's voice dose not match with background content that are plays
Mera Abhi graduation hu he Mene Mechanical Engineering BTech ki Hai me Data analysis me Apna career Bana skat ho Kya
Ashok Kumar Sonkar
Super Duper Traning
How to download in mac m1?
I want to assignment answer and data. excellent teach
excellent teaching technique...one of the best course content...