面试遇到几次类似的题目了，不会做，来大神

Question

Answer 1

假设表名为 t_test

select
t1.Name 'in Name',
t1.Number 'in Number',
t2.Name 'out Name',
t2.Number 'out Number'
from t_test t1 left join t_test t2 on t1.relationId = t2.id
如此,答案肯定对,欢迎采纳,欢迎关注