select problem

[mahmoudinirat]

i have 3 tables like this t1 --->table1 t1Id t1Name 1 jj 2 qq t2----->table2 t2Id t2Name 1 rr 2 uu t3---table 3 t3Id tableName 1 t1 2 t2 i need the foolwing result name jj uu

[Blue_Boy]

select t1.t1Name,t2.t2Name from t1,t2,t3 where t1.t1id=t2.t2id and t1.t1id=t3.t3id and t2.t2id=t3.t3id Hope it will hep you.

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.

[Senthil_M]

Please give more details about the relationship between those 3 tables.