MySQL Inner Join - Mysql

How to inner join in mysql?

Snippet Code


  
Rate this page :
  [ 0 votes]

INNER JOIN is used to return all the records (or rows) existing in both tables as long as there is a match between the columns in both tables.

Syntax: SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name=table2.column_name; Eg: SELECT name,dept FROM student T1 INNER JOIN student_detail T2 ON T1.id = T2.id;

Tags


Ask Questions

Ask Question