I have 8 different tables in SQL server , I want all tables columns in single report?

Question

1.00/5 (1 vote)

See more:

SQL-Server-2012

in my DB i have 8 type of different tables and each table i want few columns like this way total 8 tables columns in single out put .

so please give me the example query .

sql server 2012, win 10 os .

What I have tried:

i tried join's . but it showing same data in each column (what i have in first record in my table).

Posted 30-Nov-17 20:02pm

Member 13062587

Updated 3-Dec-17 22:40pm

Add a Solution

Comments

RDBurmon 1-Dec-17 2:20am

do they have same columns?

RDBurmon 1-Dec-17 2:20am

Do they contain same data sets? Can you give us some sample?

Suvendu Shekhar Giri 1-Dec-17 2:29am

More info required.. share some sample data/column structure.

itsmypassion 1-Dec-17 3:06am

Please provide table structure and sample data

Richard Deeming 1-Dec-17 12:41pm

Are you looking for the UNION[^] operator?

Rajesh Pandya 1-Dec-17 13:18pm

Share the query in which you have used join

1 solution

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)

Prashanth Mundath · Answer 1 · 2017-12-03T22:40:00

You can get the output with proper join conditions and using alias names. For example you can check the below query.

Example: Select T1.Column1,T1.Column2,T2.Column2,T2.Column2,T3.Column1,....
From Table T1 Inner Join Tbale T2 on T1.Column1=T2.Column1
Inner Join Table T3 on T3.Column1=T2.Column1
Inner Join Table T4 on T4.Column1=T3.Column2