0
Joins in sql
Someone please make me understand the JOINS in mysql with proper example..
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
+ 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/
+ 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
+ 1
Yeah i already referred that..but want more clearity..
+ 1
Best visual explanation of SQL joins:
https://www.flickr.com/photos/el_mojo/3057170865/
0
Please answer to my probolem too.
https://www.sololearn.com/Discuss/2912329/sql-vendor-join