我有两个表：表t1中有如下字段：id，A，B表t2中有如下字段：C，D其中A，B字段中的值在C字段中必有唯一的对应，也就是说C是A，B的外键。现在我希望通过接收用户提供的id输出如下结果：id，A，B，D1（对应于A的），D2（对应与B的）我试着这样写的sql语句，但是运行结果无法显示D2：SELECT t1.id, t1.A, t1.B, t2a.D AS D1, t2b.D AS D2
FROM t1 INNER JOIN t2 as t2a ON t1.A=t2a.C INNER JOIN t2 as t2b ON t1.A=t2b.C
WHERE t1.id=123;请问大家，应该怎么写呢？谢谢！
FROM t1 INNER JOIN t2 as t2a ON t1.A=t2a.C INNER JOIN t2 as t2b ON t1.A=t2b.C
WHERE t1.id=123;请问大家，应该怎么写呢？谢谢！
FROM t1 INNER JOIN t2 as t2a ON t1.A=t2a.C INNER JOIN t2 as t2b ON t1.B=t2b.C
WHERE t1.id=123;