Mysql Joins - Mysql
How to use Joins in Mysql statement?
Snippet Code
Rate this page :
|
[ 1 votes]
|
MySQL JOIN is used to join multiple tables using the keyword JOIN in Mysql. In the below example, student and student_detail table are joined together.
Syntax:
SELECT * FROM table1 JOIN table2 ON (table1.column_name=table2.column_name);
Eg:
SELECT * FROM student JOIN student_detail ON (student.id = student_detail.regnum);
