quite a simple one, I just need to brush up on a little SQL.
Essentially I have two tables in SQL, one called expired_ml and the other one called expired_old.
All I want to do is create a view that has all of the expired_Ml without any of the fields that are the same in expired_old. This is what I currently have:
FROM dbo.[expired old] INNER JOIN
dbo.ML_Expired_db ON dbo.[expired old].Company = dbo.ML_Expired_db.Company
which obviously picks up the common ones, I want the uncommon ones from ML-Expired_db
thank you for your help!!