inner join vs join code example
Example 1: only join in sql
They are functionally equivalent, but INNER JOIN can be
a bit clearer to read, especially if the query has
other join types (i.e. LEFT or RIGHT or CROSS)
included in it.
Example 2: difference between inner join vs outer join
INNER JOIN:
is used when retrieving data from multiple
tables and will return only matching data.
LEFT OUTER JOIN:
is used when retrieving data from
multiple tables and will return
left table and any matching right table records.
RIGHT OUTER JOIN:
is used when retrieving data from
multiple tables and will return right
table and any matching left table records
FULL OUTER JOIN:
is used when retrieving data from
multiple tables and will return both
table records, matching and non-matching.
Example 3: sql inner join
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
Example 4: 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 5: inner join vs outer join
INNER JOIN:
is used when retrieving data from multiple
tables and will return only matching data.
FULL OUTER JOIN:
is used when retrieving data from
multiple tables and will return both
table records, matching and non-matching.