How to add two separated query result in two different column using SQL server

Question

1.00/5 (2 votes)

See more:

Hello,

I am trying to add two separated Query result from two different column

What I have tried:

Query1="select column from table1" 
Query2="select column from table1"

Result:
table should be like this
Col1-Query1  Col2-Query2
    1              1
    2              2
    3              3

Posted 23-May-17 9:01am

Amar P Sutar

Updated 23-May-17 11:49am

v2

Add a Solution

Comments

Michael_Davies 23-May-17 15:06pm

Have you looked at using a UNION?

Amar P Sutar 23-May-17 15:24pm

Yes sir I was used union but it will combine data from two column in one

ZurdoDev 23-May-17 15:36pm

You need to join the tables. If they cannot be joined then you might look into UNION and then PIVOT.

Amar P Sutar 23-May-17 15:25pm

but i want to two different columns

CHill60 23-May-17 15:48pm

What you have shown is getting the same column from the same table twice.
I'm fairly sure that isn't really what you want.
Why not give a real example so we can see what you mean

1 solution

Add a Solution

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

Maciej Los · Answer 1 · 2017-05-23T11:49:00

Solution 1

All you need to do is to read about Visual Representation of SQL Joins[^]. Depending on situation you may want to use INNER or LEFT or RIGHT or CROSS JOIN.

Posted 23-May-17 11:49am

Maciej Los

How to add two separated query result in two different column using SQL server

1 solution

Solution 1

Add your solution here

Preview 0

How to add two separated query result in two different column using SQL server

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us