Inner Join Mutiple Years with 1 query.

[gold007eye]

Is there away that I could have 1 select query capture the information I need for multiple years as opposed to having to create a seperate query for each year? Here is my code:

SELECT [Application Data - NE].Year, Julian.Calendar04, [Application Data - NE].CCN
FROM Julian INNER JOIN [Application Data - NE] ON (Julian.Julian = [Application Data - NE].Julian) AND (Julian.Year04 = [Application Data - NE].Year)
WHERE ((([Application Data - NE].Year)="04"));