This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.
This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.This Example illustrates how to use the inner join clause in the sql query. The inner join return rows when there is at least one match in both tables.
This is the good example to understand inner join clause because in this example we use a join clause between only two table and display it as the table format on the browser. We use "emp" table and "message" table and find the emp.name from emp table and find the message.messages from message table where emp.emp_id and message.emp_id both are equal. The fetched result display on teh browser as below and the complete source code is available below for download or copy the code as per your need.
The "INNER JOIN" keyword is used for join the data.
Table: emp
Table: message
Source Code of innerJoin.php
<?php
|
Output: