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

4 votes290 views1 answer
Sql list users and roles
SQL
1 vote318 views1 answer
How to truncate a table in databse
SQL
0 vote339 views1 answer
How to reset table in sql server
SQL
0 vote369 views1 answer
Create-table-with-index-organization
SQL
0 vote345 views1 answer
Hour differeence in mysql
SQL
3 votes333 views2 answers
Oracle drop column
SQL
0 vote375 views1 answer
How to get button for every record from mysql
SQL
1 vote337 views1 answer
Mysql view current queries
SQL
0 vote338 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote324 views1 answer
Sql server get users
SQL