inner join select code example

Example 1: 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 2: sql select inner join example

SELECT Orders.OrderID, Customers.CustomerName
FROM Orders
INNER JOIN 
  Customers ON Orders.CustomerID = Customers.CustomerID;

Tags:

Misc Example

Related