P Narasimha

P Narasimha

  • 703
  • 1.3k
  • 248.3k

select top 1 column data from the 3 tables using joins or any other

Nov 29 2012 8:41 AM
   
  Hi All,

  Can you please help me on this.
  I have tables t1,t2,t3
  common column an in 3 tables id.
 now i want select t1.colm1,t1.clom2,t2.clom1,t2.clom3,t3.clomn2 from t1,t2,t3 and  selcet top1 t1.clomn1 from t1 table and get data from 3 table using joins or any other like where condition using id column is the common for 3 tables.

please help me on this.

Advanced Thank you.

Regards,
Narasimha

Answers (3)