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 vote254 views1 answer
Oracle drop type
SQL
10 votes235 views3 answers
How to fetch first 5 characters in sql
SQL
2 votes245 views1 answer
Sql update from different table
SQL
0 vote244 views1 answer
Custom row number
SQL
4 votes220 views1 answer
Update table from another table oracle
SQL
2 votes221 views1 answer
Create table with primary key
SQL
19 votes234 views6 answers
What is mySQL
SQL
1 vote250 views1 answer
Table infromation in sql server
SQL
32 votes258 views6 answers
Insert select
SQL
2 votes238 views1 answer
Copy all values of a column to another column in sql in same table
SQL