Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 429
  • Last Modified:

union all between three table

SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d630590]
  where sent = 0


SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d732590]
  where sent = 0


SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d84444]
  where sent = 0


i want to union the three table and order by datein and timein
0
AFIF JABADO
Asked:
AFIF JABADO
2 Solutions
 
Dale BurrellDirectorCommented:
Add " union all " between each query and add " order by datein, timein" after the last query.
0
 
jogosCommented:
SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d630590]
  where sent = 0

union all
SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d732590]
  where sent = 0

union all
SELECT [ID]
      ,[ReqPort]
      ,[Message]
      ,[MSISDN]
      ,[Datein]
      ,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[CGI_SMS_d84444]
  where sent = 0
order by datein ,timein

Open in new window

0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now