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

Question

   

  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

Answer 1

http://www.c-sharpcorner.com/UploadFile/mahesh/CreatingDBProgrammaticallyMCB11282005064852AM/CreatingDBProgrammaticallyMCB.aspx