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;
