Inner join
In case we want to show only matching results, we use inner join in that case.
e.g:-we have two tables,then using inner join will return only matching results

SELECT A1.pname STORE
 FROM table1 A1
  INNER JOIN table2 A2
 ON A1.pname = A2.pname
 GROUP BY A1.pname;

 table1

 
table2