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

1 vote296 views1 answer
Oracle grant on all tables in schema
SQL
1 vote309 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote307 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
3 votes317 views1 answer
Oracle list privileges
SQL
0 vote331 views1 answer
Typical max-connect-errors mysql
SQL
16 votes315 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
1 vote293 views1 answer
Count mysql server db tables
SQL
0 vote304 views1 answer
Split string by comma in sql server
SQL
0 vote324 views1 answer
Sql quary intervewi question
SQL
3 votes294 views2 answers
Mysql create timestamp column
SQL