How can I do this Query

[tonybernardo]

Table Customer with
column Key
column DOB Format: 1962/06/23

Table Retirement with column
column Key
column Age Ex:65

I need a query to list all customer's retiring on a date range.

Select * from Customer,Retirement where Customer.Key = Retirement.Key AND ??????

 

[wsmall73]

Select * from Customer,Retirement where Customer.Key = Retirement.Key AND Retirement.Age between DATEDIFF ( 'yyyy', Customer.DOB , startdate ) and DATEDIFF ( 'yyyy', Customer.DOB, enddate )

 

[MeanGreen]

This should get you a list of Customer who retire in next 30 days:

Select * from Customer C join Retirement R
on C.iKey = R.iKey
where R.Age * 12 between DateDiff(month,DOB,GetDate())
and DateDiff(month,DOB,DateAdd(day,30,GetDate()))

Hope this helps.