送分100分:三个表的左连接语句如何写
表1有字段:A、B、C,表2有字段:D、E、F,表3有字段:G、H、I
连接条件是A=D且 F=I
请提供一下表A左连接B、C的SQL语句
[解决办法]
select t1.a,t1.b,t1.c,t2.d,t2.e,t2.f,t3.g,t3.h,t3.ifrom t1left join t2 on t1.a=t2.dleft join t3 on t2.f=t3.i
[解决办法]
select *from t1left join t2 on t1.a=t2.dleft join t3 on t2.f=t3.i