求sql语句

[xiaowai0219]

表1含A，B等字段

表2含B，C等字段

表3含D，A等字段

需要得到表含字段D，C，A，求sql语句。本人新手，还请指点。谢谢

[江南小鱼]

select t3.D,t2.C,t1.A
from 表1 t1
left join 表2 t2 on t1.B=t2.B
left join 表3 t3 on t1.A=t3.A

[暗夜之王]

SELECT  表3.D,表2.C,表3.A FROM  表1 INNER JOIN 表2 ON 表1.B=表2.B
	INNER JOIN 表3 ON 表1.A=表3.A

[HelloWordGirl]

SELECT t3.D, t2.c, t1.A FROM Temp_1 t1 INNER JOIN Temp_2 t2 ON t1.B=t2.B INNER JOIN Temp_3 t3 ON t1.A=t3.A

[hepe00]

select t1.A,t2.C,t3.D from t1
	cross apply t2 
	cross apply t3 

[hepe00]

select t1.A,t2.C,t3.D from t1
	cross apply t2 
	cross apply t3