I need to UPDATE a field in a table. tbl2015 will have data that is NOT in tbl2014. Those rows that are NOT IN tbl2014 I want to SET ComparePriorYr = '2'. I am having trouble with my query. Here is what I have so far.
SET ComparePriorYr = '2'
FROM tblStockCertInfo_2015 tbl2015
LEFT JOIN tblStockCertInfo_2014 tbl2014 ON tbl2014.InfoUniqueKey = tbl2015.InfoUniqueKey
What type of JOIN do I use to get only the data that is in tbl2015 and NOT IN tbl2014?