inner join example

Example 1: is natural and inner join same

A Inner Join is where 2 tables are joined on the basis of common columns 
mentioned in the ON clause. ... 
Inner join and natural join are almost same but there is a slight 
difference between them. The difference is in natural join no need to 
specify condition but in inner join condition is obligatory.

Example 2: inner join mysql

SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;

Example 3: inner join

INNER JOIN is used when retrieving data from
multiple tables and will return only matching data.

example=
Select P.FIRST_NAME , M.DRUG_ID
FROM PATIENTS P
INNER JOIN MEDICATIONS M ON P.PATIENTS_ID = M.PATIENTS_ID

Example 4: Inner join sql

SELECT column_name(s)

FROM table1

INNER JOIN table2
 ON table1.column_name = table2.column_name;