inner join and outer join with 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
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