I have to do a select staement to show all partnumbers not sold in the last 3 years. I can easliy grab all part numbers that did sell in the last 3 years:
FROM dbo.PartNumbers INNER JOIN
dbo.OrderDetails ON dbo.PartNumbers.PartNumberID = dbo.OrderDetails.PartNumberID
WHERE (dbo.OrderDetails.ShipDate >= CONVERT(DATETIME, '2004-10-12 00:00:00', 102))
Now how do I get the opposite of that?