how to use to inner join with mysql?

SELECT * FROM `table` INNER JOIN `table_two` ON (`table.row` = `table_two.otherrow`) It basically does the same as the WHERE clause but then on 2 tables, in this example comparing the column row in the table table with the column otherrow in the table table_two. Hope that helps :).

INNER join SQL command is mostly used to join one table to it self. The biggest advantage of doing this is to get linking information from the same table. We will try to understand this with an example. The best example of INNER join will be employee table where we will keep the employee and its manager as a single record. This way by linking to the table it self we will generate a report displaying it as two linked tables. Each record will have one additional field storing the data of the manager by keeping the employee ID and we will use M_ID ( manager ID ) to link with main employee ID. This way we will link two virtual tables generated from one main table. Here is the table.