Problem in fetching data Using Inner Join and Where clause Simultaneously

See more:

C#

SQL

database

SqlDataSource

I want to perform two operations i.e, INNER JOIN and use of WHERE clauses simultaneously in single query:
first one is for Inner join another is for Where clause:-

SELECT rpd.registration_no,rpd.name, rpd.marriage_anniversary_date,fd.name
FROM rpd
INNER JOIN fd
ON rpd.registration_no=fd.registration_no and rpd.marriage_anniversary_date=fd.marriage_anniversary_date

SELECT registration_no,name, marriage_anniversary_date
FROM rpd WHERE ((DATEDIFF(dd, getdate(), DATEADD(yyyy, DATEDIFF(yyyy, marriage_anniversary_date, getdate()) + 1, marriage_anniversary_date))) % 366 <= 10) order by marriage_anniversary_date desc

This is for fetching birthdays in next 10 days.

I want to make one single query for both...