select a.id,a.name,b.id,b.address,b.tell,c.id,c.time from 表A a,表B b,表C c where name='"+name+"'and a.id=b.id and b.id=c.id and c.id=a.id
[最优解释] select distinct a.id,a.name,b.address,b.tell,c.time from 表A a,表B b,表C c where name='"+name+"'and a.id=b.id and a.id=c.id [其他解释] SELECT B.*,C.* FROM B INNER JOIN C ON B.ID=C.ID WHERE B.ID IN(SELECT ID FROM A WHERE NAME='"+name+"') [其他解释] distinct。。。。这个是重点。select distinct **** [其他解释] 2楼正解