ahmed elbarbary

ahmed elbarbary

  • 1k
  • 1.6k
  • 228.2k

How to select data from RequestesEmail table based on two co

Mar 16 2020 10:32 PM
How to select data from RequestesEmail table based on two condition on same time ?
I work on SQL server 2012
I have table request emails register email requested and replies
structure table as following :
  1. CREATE TABLE [dbo].[RequestsEmail](  
  2.     [EmialRequestID] [int] IDENTITY(1,1) NOT NULL,  
  3.     [RequestID] [intNULL,  
  4.     [EmailID] [nvarchar](250) NULL,  
  5.     [ReplyToID] [nvarchar](250) NULL,  
  6.     [EmailDate] [datetime] NULL,  
  7. ON [PRIMARY 
  8. INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])   
  9. VALUES ( 39502, N'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com', N'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com','2020-03-17 05:08:11.740')  
  10. INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])   
  11. VALUES ( 39504, N'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com', N'ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com','2019-05-05 05:08:11.740')  
  12. INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])   
  13. VALUES ( 39504, N'ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com'NULL,'2020-03-17 05:10:11.740')  
  14. INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])   
  15. VALUES ( 39504, N'mmoyedb2a824b5446cdd486f2@tw.diodes.com'NULL,'2020-03-17 05:15:11.740')  
  16. INSERT [dbo].[RequestsEmail] ( [RequestID], [EmailID], [ReplyToID], [EmailDate])   
  17. VALUES ( 39504, N'ddlyoyedb2a824b5446cdd486f2@tw.diodes.com', N'ddlyoyedb2a824b5446cdd486f2@tw.diodes.com','2018-02-09 05:15:11.740')   
all data on table as below
EmialRequestID RequestID EmailID ReplyToID EmailDate
1 39502 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 2020-03-17 05:08:11.740
2 39504 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 2019-05-05 05:08:11.740
3 39504 ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com NULL 2020-03-17 05:10:11.740
4 39504 mmoyedb2a824b5446cdd486f2@tw.diodes.com NULL 2020-03-17 05:15:11.740
5 39504 ddlyoyedb2a824b5446cdd486f2@tw.diodes.com ddlyoyedb2a824b5446cdd486f2@tw.diodes.com 2018-02-09 05:15:11.740
 
desire result is
EmialRequestID RequestID EmailID ReplyToID EmailDate
1 39502 ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com ac68a541d8854b2a824b5446cdd486f2@tw.diodes.com 17/03/2020
3 39504 ffgd451d8854b2a824b5446cdd486f2@tw.diodes.com NULL 17/03/2020
4 39504 mmoyedb2a824b5446cdd486f2@tw.diodes.com NULL 17/03/2020
 
Actually i need to make select statement display or show all data on table RequestEmail above structure
where
first condtition
ReplyToID is null and EmailDate equal datetoday
and also second condition
select EmailID where equal ReplyToID and EmailDate is dateToday
two condition on same time must show .
so how to do that please ?

Answers (2)