Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
select top 1 column data from the 3 tables using joins or any other
P Narasimha
Nov 29 2012 8:41 AM
2.7k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
how to change null constraint into notnull constraint(Below is my table creation)
How to create stored procedure , i want show some select