Excluding values from a table join
Ok, I am sure there is a way to do this:)
I have 2 tables, say a year table with yearID and Year
and a master year table with the same masterYearID and MasterYear
the year table is a list of years
the master is a list of years in use
I want to get a list of years from years that excludes the years in master, and I really just have no idea where to start.
i have tried select where <> master years with no luck.
Any help would be great.