SQL how to combine multiple SQL Queries into one output

Question

I am having troubles combining multiple queries into one output. I am a beginner at SQL and was wondering if anyone can provide me with some feedback on how to get this done.

Here is my code:

SELECT [status], [queryno_i] as 'Query ID', [assigned_to_group] as 'Assigned To Group', [issued_date] as 'Issuing Date',
CASE
    WHEN [status] = 3 THEN [mutation]
    ELSE NULL
END AS 'Closing Date'
 FROM tablename.[tech_query] WITH (NOLOCK)


SELECT
CASE
    WHEN [status] = 3 THEN 'CLOSED'
    ELSE 'OPEN'
END AS [State]
 FROM tablename.[tech_query] WITH (NOLOCK)


SELECT
CASE
    WHEN [status] = 3 THEN [mutation_int]-[issued_date_INT]
    ELSE NULL
END AS [TAT]
 FROM tablename.[tech_query] WITH (NOLOCK)

You need UNION: techonthenet.com/sql/union.php

Mörre
– Mörre

2013-12-06 21:24:00 +00:00
Commented Dec 6, 2013 at 21:24 — Mörre
– Mörre, Commented Dec 6, 2013 at 21:24
do you get any errors?

DevelopmentIsMyPassion
– DevelopmentIsMyPassion

2013-12-06 21:24:01 +00:00
Commented Dec 6, 2013 at 21:24 — DevelopmentIsMyPassion
– DevelopmentIsMyPassion, Commented Dec 6, 2013 at 21:24
@Mörre can we use union even if there are uneven columns?

DevelopmentIsMyPassion
– DevelopmentIsMyPassion

2013-12-06 21:25:24 +00:00
Commented Dec 6, 2013 at 21:25 — DevelopmentIsMyPassion
– DevelopmentIsMyPassion, Commented Dec 6, 2013 at 21:25
The word combine can mean so many different things

James A Mohler
– James A Mohler

2013-12-06 21:25:45 +00:00
Commented Dec 6, 2013 at 21:25 — James A Mohler
– James A Mohler, Commented Dec 6, 2013 at 21:25
@Mörre but that was for sqllite

DevelopmentIsMyPassion
– DevelopmentIsMyPassion

2013-12-06 21:29:19 +00:00
Commented Dec 6, 2013 at 21:29 — DevelopmentIsMyPassion
– DevelopmentIsMyPassion, Commented Dec 6, 2013 at 21:29

Jorge Campos · Accepted Answer · 2013-12-06 21:25:42Z

2

If you want all in one row just put all together

SELECT [status], 
      [queryno_i] as 'Query ID', 
      [assigned_to_group] as 'Assigned To Group', 
      [issued_date] as 'Issuing Date',
      CASE WHEN [status] = 3 THEN [mutation] ELSE NULL END AS 'Closing Date',
      CASE WHEN [status] = 3 THEN 'CLOSED' ELSE 'OPEN' END AS [State],
      CASE WHEN [status] = 3 THEN [mutation_int]-[issued_date_INT] ELSE NULL 
            END AS [TAT]
 FROM tablename.[tech_query] WITH (NOLOCK)

answered Dec 6, 2013 at 21:25

Jorge Campos

23.9k7 gold badges65 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

James Smith · Accepted Answer · 2013-12-06 21:26:05Z

1

You can use a UNION clause

http://www.w3schools.com/sql/sql_union.asp

SELECT 1 
  UNION ALL
SELECT 2
  UNION ALL
SELECT 3

However, from looking at your 3 statements, all 3 selects are coming from the same table, so you may be able to just combine and use CASE statements to get your results without using a Union.

answered Dec 6, 2013 at 21:26

James Smith

1,1221 gold badge11 silver badges14 bronze badges

Comments

Brent · Accepted Answer · 2013-12-06 21:31:53Z

With SQL, everything would have to be one result set. In order for you to return the results of all of these queries, they all would have to have the same columns (and data types).

Would you able to combine everything into one select query?

SELECT 
    [status]
    , [queryno_i] as 'Query ID'
    , [assigned_to_group] as 'Assigned To Group'
    , [issued_date] as 'Issuing Date'
    , CASE
        WHEN [status] = 3 THEN [mutation]
        ELSE NULL
        END AS 'Closing Date'
    , NULL AS State
    , NULL AS Tat
    , 1 AS QueryNumber
FROM 
    [tech_query] 

UNION ALL

SELECT NULL,NULL,NULL,NULL,NULL,
    CASE
        WHEN [status] = 3 THEN 'CLOSED'
        ELSE 'OPEN'
    END AS [State]
    , NULL
    , 2 AS QueryNumber
FROM 
    [tech_query] 

UNION ALL

SELECT NULL,NULL,NULL,NULL,NULL, NULL
CASE
    WHEN [status] = 3 THEN [mutation_int]-[issued_date_INT]
    ELSE NULL
END AS [TAT]
, 3 AS QueryNumber
FROM 
    [tech_query]

James A Mohler · Accepted Answer · 2013-12-06 21:25:09Z

0

Are you looking for something like this?

SELECT [status], [queryno_i] as 'Query ID', 
   [assigned_to_group] as 'Assigned To Group', [issued_date] as 'Issuing Date',
CASE
   WHEN [status] = 3 THEN [mutation]
   ELSE NULL
END AS 'Closing Date',

CASE
   WHEN [status] = 3 THEN 'CLOSED'
   ELSE 'OPEN'
END AS [State],

CASE
   WHEN [status] = 3 THEN [mutation_int]-[issued_date_INT]
   ELSE NULL
END AS [TAT]


FROM tablename.[tech_query] WITH (NOLOCK)

answered Dec 6, 2013 at 21:25

James A Mohler

11.1k15 gold badges51 silver badges76 bronze badges

Comments

Captain Redbelly · Accepted Answer · 2013-12-06 21:25:47Z

0

Case statements are inline

SELECT 
  [status], 
  [queryno_i] as 'Query ID', 
  [assigned_to_group] as 'Assigned To Group', 
  [issued_date] as 'Issuing Date',
  CASE
      WHEN [status] = 3 THEN [mutation]
      ELSE NULL
  END AS 'Closing Date',
  CASE
    WHEN [status] = 3 THEN 'CLOSED'
    ELSE 'OPEN'
  END AS [State],
  SELECT
  CASE
      WHEN [status] = 3 THEN [mutation_int]-[issued_date_INT]
      ELSE NULL
  END AS [TAT]
  FROM tablename.[tech_query] WITH (NOLOCK)

Why the nolock?

answered Dec 6, 2013 at 21:25

Captain Redbelly

2805 silver badges11 bronze badges

Collectives™ on Stack Overflow

SQL how to combine multiple SQL Queries into one output

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related