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.

Thanks

How about posting the query that you tried?

_________________________
- Vijay G
Strive for Perfection

There are 3 ways of doing this and here's a link that discusses all 3 options:

http://www.sql-server-helper.com/faq/select-p01.aspx

Refer to the 3rd FAQ question.

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp