0

Joins in sql

Someone please make me understand the JOINS in mysql with proper example..

23rd Oct 2021, 3:07 PM
Anima Singh Dhabal
Anima Singh Dhabal - avatar
7 Respuestas
+ 4
Sololearn's SQL course covers all about this give it a look https://www.sololearn.com/learn/SQL/1866/?ref=app https://www.sololearn.com/learn/SQL/1865/?ref=app Don't forget to look into comments of each lessons
23rd Oct 2021, 3:20 PM
AKSHAY🇮🇳
AKSHAY🇮🇳 - avatar
+ 3
There should be join in SQL not MySQL. MySQL is a RDBMS and SQL is query language. A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table You can see examples here: https://www.geeksforgeeks.org/sql-join-set-1-inner-left-right-and-full-joins/
23rd Oct 2021, 3:21 PM
A͢J
A͢J - avatar
+ 2
If you want more clearly then you can refer YouTube tutorials or books joins are very important and most of the interview questions are asked by this topic so read deeply
23rd Oct 2021, 5:52 PM
A S Raghuvanshi
A S Raghuvanshi - avatar
+ 1
Yeah i already referred that..but want more clearity..
23rd Oct 2021, 3:21 PM
Anima Singh Dhabal
Anima Singh Dhabal - avatar
+ 1
Best visual explanation of SQL joins: https://www.flickr.com/photos/el_mojo/3057170865/
24th Oct 2021, 2:18 AM
Brian
Brian - avatar
27th Oct 2021, 8:07 AM
william