Inner Join Examples
Example 1
Select c.contract_id, p.product_id, p.amount
From products p, contracts c
Where p.product_id = c.product_id
And p.amount > 3500
Result:
CONTRACT_ID | PRODUCT_ID | AMOUNT |
2023 | 669 | 12000.00 |
3408 | 720 | 5000.00 |
4078 | 105 | 9000.00 |
Example 2
Select cu.customer_id, cu.name,
c.contract_id, p.product_id,
p.amount
From customers cu,
products p,
contracts c
Where c.customer_id = cu.customer_id
And p.product_id = c.product_id
And p.amount > 3500
Result:
CUSTOMER_ID | NAME | CONTRACT_ID | PRODUCT_ID | AMOUNT |
1 | CUSTOMER_1 | 2023 | 669 | 12000.00 |
2 | CUSTOMER_2 | 3408 | 720 | 5000.00 |
3 | CUSTOMER_3 | 4078 | 105 | 9000.00 |