sql inner outer joins code example
Example 1: sql inner join
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
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