how to get this output

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

i have three tables

A,B,C

A columns id,d,e
B columns id,f,g
C columns id,h,i

here three columns in id is same

i need one id and three tables information

output

id, d,e,f,g,h

how to write command

Posted 17-May-12 1:24am

2011999

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2012-05-17T01:27:00

Solution 2

You need to join the tables. For tutorial, see SQL Joins[^]

So your statement could be something like

SQL

select table1.id, table1.d, table2.f...
from table1 inner join table2 on table1.id = table2.id
            inner join table3 on table2.id = table3.id

Posted 17-May-12 1:27am

Wendelius

Comments

2011999 17-May-12 7:34am

only three tables id get it but remaining data is not get it

Wendelius 17-May-12 7:46am

Do you mean you don't have matching rows on each table. If that's the case, use outer join instead of inner join.

Maciej Los 17-May-12 7:50am

If you would like to get output: id, d,e,f,g,h , the above query is correct.

Maciej Los 17-May-12 7:51am

Good answer, my 5!

Wendelius 17-May-12 7:59am

Thanks :)

Sharma Richa · Answer 2 · 2012-05-17T01:26:00

Solution 1

You have to use join.
Study about joins.

Posted 17-May-12 1:26am

Sharma Richa

sunandandutt · Answer 3 · 2012-05-17T01:30:00

A,B,C

A columns id,d,e
B columns id,f,g
C columns id,h,i

select e.id,e.coloumn1,e.coloumn2,e1.coloumn1,e1.coloumn2,e2.coloumn1,e2.coloumn2 from A e join
B e1 on e.id=e1.id join C e2 on e.id=e2.id

Here e,e1,e2 are alises of table and
e.coloumn1 contain d
e.coloumn2 contain e
e1.coloumn1 contain f
etc............