Multiple row join

SELECT l.name AS subject_name,  
  t.last_name AS student_last_name,
  st.last_name AS teacher_last_name
FROM learning AS l 
JOIN subject s ON l.subject_id=s.id
JOIN student st ON l.student_id=st.id
JOIN teacher t ON l.teacher_id=t.id;

Source: learnsql.com

Similar codes

0 vote148 views1 answer
How to join result table in mysql
SQL
10 votes146 views4 answers
Mysql one week ago
SQL
0 vote144 views1 answer
How to put is null in where in clause
SQL
0 vote138 views1 answer
Oracle simple quote
SQL
0 vote140 views1 answer
What is SQL data store?
SQL
0 vote139 views1 answer
Subquery aggregation
SQL
0 vote160 views1 answer
Postgres change the name of schema
SQL
1 vote138 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
1 vote139 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote140 views1 answer
Test the postgresql db connection
SQL