Here you go. Now you can test your query (I hope) The VINs are not real for obvioius reasons.

--===== Create the test table with

CREATE TABLE [Vehicle Detail]

(

VIN Varchar PRIMARY KEY CLUSTERED,

SerialNumber Varchar,

ProgYear Varchar,

LeaseCycle Varchar,

ModelName Varchar,

RiskNonRiskFlag Varchar,

Region Varchar,

MFG Varchar,

ReturnDate Datetime

)

CREATE TABLE [Returns Pros]

(

Region Varchar

ProgYear Varchar,

RiskNonRiskFlag Varchar,

MFG Varchar,

LeaseCycle Varchar,

ModelName Varchar,

ReturnDate Datetime,

UnitCount Float

)

--===== Setup any special required conditions especially where dates are concerned

SET DATEFORMAT (Returns Pros) MMDDYYYY ???

--===== Insert the test data into the test table

INSERT INTO [Vehicle Detail]

(VIN, SerialNumber, ProgYear, LeaseCycle, ModelName, RiskNonRiskFlag, Region, MFG, ReturnDate)

Select 'ZL152983', '1FADP3K22ZL152983', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL185223', '1FADP3K20ZL185223', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL196536', '1FADP3F27ZL196536', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL265273', '1FADP3F27ZL265273', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL196580', '1FADP3F2XZL196580', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL196590', '1FADP3F22ZL196590', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL171198', '1FADP3F29ZL171198', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL171258', '1FADP3F21ZL171258', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL171268', '1FADP3K27ZL171268', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL211529', '1FADP3F2XZL211529', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL211532', '1FADP3F2XZL211532', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'ZL211617', '1FADP3F27ZL211617', '13', '1', 'FOCUS', 'R', 'SOUTHEAST', 'FRD', NULL UNION ALL

Select 'C5216918', '1ZVBP8DM2C5216918', '11', '2', 'MUSTANG CONV', 'R', 'ATLANTIC', FRD', NULL UNION ALL

Select 'C5216923', '1ZVBP8DM2C5216923', '11', '2', 'MUSTANG CONV', 'R', 'ATLANTIC', FRD', NULL UNION ALL

Select 'D1220647', '2G1WC6E30D1220647', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', NULL UNION ALL

Select 'D1221984', '2G1WC6E31D1221984', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', NULL UNION ALL

Select 'D1259402', '2G1WC6E30D1259402', '13', '1', 'IMPALA', 'R' , 'CENTRAL', 'GMC', NULL UNION

INSERT INTO [Returns Pros]

(Region, ProgYear, RiskNonRiskFlag, MFG, LeaseCycle, ModelName, ReturnDate, UnitCount)

Select 'Atlantic', '11', 'R', 'FRD', '2', 'MUSTANG CONV', '6/3/2013', 2, NULL UNION ALL

Select 'Central' '13', 'N', 'GMC', '1', 'IMPALA', '6/3/2013', 3, NULL UNION ALL

Select 'Southeast', '13', 'R', 'FRD', '1', 'FOCUS', '1/4/2014', 12