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_detail.regnum);


Ask Questions

Ask Question