I think you might want to rethink your table schemas. This is going to get very complex very quickly and doesn't provide any immediate benefit. Perhaps your second table should be the years in which the items are sold, as opposed to not sold.
–
Craig WilsonNov 14 '10 at 13:40

In your example on the line "WHERE NOT table1.ArticleNo IN (SELECT table2.Year FROM table2);" you're comparing ArticleNo to a Year. From your data example that will never match.
–
Ash BurlaczenkoNov 14 '10 at 13:59