Member_2_6478753
asked on
union all between three table
SELECT [ID]
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[ CGI_SMS_d6 30590]
where sent = 0
SELECT [ID]
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[ CGI_SMS_d7 32590]
where sent = 0
SELECT [ID]
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[ CGI_SMS_d8 4444]
where sent = 0
i want to union the three table and order by datein and timein
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[
where sent = 0
SELECT [ID]
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[
where sent = 0
SELECT [ID]
,[ReqPort]
,[Message]
,[MSISDN]
,[Datein]
,[Timein]
FROM [CGI_SMS_SERVICES].[dbo].[
where sent = 0
i want to union the three table and order by datein and timein
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.