试试这个查询..

try this query..

Select t1.Name,t2.Name,t3.Name from Table4 t4
Inner join Table1 t1 on t1.id=t4.id1
Inner join Table2 t2 on t2.id=t4.id2
Inner join Table3 t3 on t3.id=t4.id3

它可以帮到你..





问候，>
Prakash.T

it may help you..


regards,
Prakash.T

从t1，t2，t3，t4选择t1.name，t2.name，t3.name

其中t1。 id = t4.t1id和t2.id = t4.t2id和t3.id = t4.t3id

select t1.name,t2.name,t3.name from t1,t2,t3,t4
where t1.id=t4.t1id and t2.id=t4.t2id and t3.id=t4.t3id