I may just be setting up my query completely incorrect but my expected result set that I need returned is `Nuestra B & Nosotros B` since they fall into the date range respectively. I.E. Nuestra B `feeduedate >= '20160301' AND fj.feeduedate <='20160330'` and for Nosotros B `fe.ViolationDate >= '20170601' AND fe.ViolationDate <= '20170606'` they fall into place. However when I run this query attempting to return the result I get 0 returned in my result set. What is incorrect with my query? Below is sample data & DDL CREATE TABLE [dbo].[fei]( [violatorsName] [varchar](500) NOT NULL, [violationNumber] [varchar](100) NOT NULL, [violationDate] [date] NOT NULL ) ON [PRIMARY] CREATE TABLE [dbo].[FJI]( [violatorsName] [varchar](500) NOT NULL, [VIN] [varchar](100) NOT NULL, [vfees1] [float] NOT NULL, [vfees2] [float] NOT NULL, [vfees3] [float] NOT NULL, [vfees4] [float] NOT NULL, [vfees5] [float] NOT NULL, [vfees6] [int] NULL, [feeduedate] [date] NULL, [totalvfees] [float] NOT NULL, [totalvfeespaid] [float] NOT NULL, [vfeesremaining] [float] NOT NULL, [vfee7] [float] NOT NULL, [vfee8] [float] NOT NULL, [vfee9] [float] NOT NULL, [vfee10] [float] NOT NULL, [vfee11] [float] NOT NULL, [vfee12] [float] NULL, [vfee13] [float] NULL, [vfee14] [float] NULL, [vfee15] [float] NULL, [vfee16] [float] NULL ) ON [PRIMARY] INSERT [dbo].[fei] ([violatorsName], [violationNumber], [violationDate]) VALUES (N'Nostra A', N'3244', CAST(0xE63C0B00 AS Date)) INSERT [dbo].[fei] ([violatorsName], [violationNumber], [violationDate]) VALUES (N'Nuestra B', N'408', CAST(0xE53C0B00 AS Date)) INSERT [dbo].[FJI] ([violatorsName], [VIN], [vfees1], [vfees2], [vfees3], [vfees4], [vfees5], [vfees6], [feeduedate], [totalvfees], [totalvfeespaid], [vfeesremaining], [vfee7], [vfee8], [vfee9], [vfee10], [vfee11], [vfee12], [vfee13], [vfee14], vfee15, vfee16) VALUES (N'Nosotros A', N'41', 1917.71, 0, 898.3, 10.870000, 0, 1906, CAST(0x353B0B00 AS Date), 9948, 9773, 7867, 1429.5, 9296.5, 401.53999999999996, 9371, 2826.88, 20782, 28875.31, 222059.4, 0, 0) INSERT [dbo].[FJI] ([violatorsName], [VIN], [vfees1], [vfees2], [vfees3], [vfees4], [vfees5], [vfees6], [feeduedate], [totalvfees], [totalvfeespaid], [vfeesremaining], [vfee7], [vfee8], [vfee9], [vfee10], [vfee11], [vfee12], [vfee13], [vfee14], vfee15, vfee16) VALUES (N'Nosotros B', N'211', 2339.45, 0, 1545.14, 2.2, 69.13, NULL, CAST(0x2D3B0B00 AS Date), 6192, 6192, 6192, 0, 6192, 3404, 2788, 3955.9299999999994, 0, 4856.81, 0, 0, 15421.550000000001) SELECT ISNULL(fe.violatorsName,fj.violatorsName) , TotalSW = COUNT(fe.violationNumber) , TotalSNT = COUNT(fj.VIN) , totalvfees = SUM(totalvfees) , calculatedvfee = SUM(COALESCE(totalvfees,0)-COALESCE(vfee9,0)) , AdminFee = SUM(COALESCE(vfee12,0)) , SecFee = SUM(COALESCE(vfee13,0)) FROM fei fe FULL OUTER JOIN fji fj ON fj.violatorsName =fe.violatorsName WHERE fe.ViolationDate >= '20170601' AND fe.ViolationDate <= '20170606' AND fj.feeduedate >= '20160301' AND fj.feeduedate <='20160330' GROUP BY ISNULL(fe.violatorsName, fj.violatorsName) ViolationDate should return Nuestra B Feeduedate should return Nosotros B