mysql - 表 1、表 2 的多列左连接

Question

我有两个表:table1，table2，如下所示

table1:
id   name
1    tamil
2    english
3    maths
4    science

table2:
p1 p2 p3 p4 stat name
1  2  4  3   A   raja
2  3  4  1   A   maha

我的预期输出是

p1       p2       p3       p4
tamil   english   science  maths
english maths     science  tamil

有人能帮我找出确切的查询吗？那应该使用左外连接。

Answer 1

select P1, t1.Name,P2, t3.Name, P3,t4.Name, P4 , t5.Name From Table2 T2
left join table1  t1 on 
T2.P1 = T1.Id
left join  table1  t3 on 
T2.P2 = T3.Id
left join  table1  t4 on 
T2.P3 = T4.Id
 left join  table1  t5 on 
T2.P4 = T5.Id