MySQL INNER JOIN

The INNER JOIN keyword returns rows when there is at least one match in both tables.

family Table:

Position	Age
Dad	41
Mom	35
Daughter	17
Dog	12

food Table:

Meal	Position
Rice	Dad
Dosa	Mom
Idly
Egg	Dog

The INNER JOIN keyword returns rows when there is at least one match in both tables. If there are rows in "family" that do not have matches in "food", those rows will NOT be listed.

<?php 

/* Make a MySQL Connection */
$query = "SELECT family.Position, food.Meal FROM family INNER JOIN food ON 

family.Position = food.Position";
  
$result = mysql_query($query) or die(mysql_error());


// Print out the contents of each row into a table 
while($row = mysql_fetch_array($result)){
 echo $row['Position']. " - ". $row['Meal'];
 echo "
";
}
?>
Output:-
Mom - Rice
Dad - Dosa
Dog - Egg