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 vote205 views1 answer
Aktor yang pernah terlibat lebih dari 3 film di sql
SQL
0 vote202 views1 answer
How to create an SQL save method in ruby
SQL
6 votes206 views4 answers
Remove spaces sql server
SQL
0 vote178 views0 answer
SQL
0 vote202 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote192 views1 answer
Min salary in sql
SQL
-1 vote215 views1 answer
Can pandas fetch data from sql
SQL
0 vote210 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote186 views1 answer
Mysql earlier than date
SQL
1 vote209 views1 answer
Mysql current time
SQL