Mysql Joins - Mysql

How to use Joins in Mysql statement?

Snippet Code


  
Rate this page :
  [ 0 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);

Tags


Ask Questions

Ask Question