这个SQL怎么写???在线等!!!

[tainy]

ABC三个表相互关连,并且这三个表的关系是(A.A1=B.b1 and b.b1=c.c1),要选择B表中所有满足B.h=1的记录(去掉重复).SQL语句怎么写?

[arclala]

select distinct * from a,b,c where A.A1=B.b1 and b.b1=c.c1 and B.h=1

[yljbj]

SELECT DISTINCT .......
FROM A,B,C
WHERE A.A1=B.B1 AND B.B1=C.C1 AND B.H=1

[rexsp]

select distinct * from a A,b B,c C where A.A1=B.b1 and b.b1=c.c1 and B.h=1

[baisun]

select * from a,b,c where A.A1=B.b1 and b.b1=c.c1 and B.h=1