Breaking News: Grepper is joining You.com. Read the official announcement!

Inner join - to join 3 tables - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/

Alert Albatross answered on July 14, 2022 Popularity 10/10 Helpfulness 5/10

answer Inner join - to join 3 tables - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/

Inner join - to join 3 tables - https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-inner-join/

Comment

SELECT
	c.customer_id,
	c.first_name customer_first_name,
	c.last_name customer_last_name,
	s.first_name staff_first_name,
	s.last_name staff_last_name,
	amount,
	payment_date
FROM
	customer c
INNER JOIN payment p 
    ON p.customer_id = c.customer_id
INNER JOIN staff s 
    ON p.staff_id = s.staff_id
ORDER BY payment_date;
Code language: SQL (Structured Query Language) (sql)

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.postgresqltutorial.com

Tags: inner-join join sql

Link to this answer
Share Copy Link