Yes,the relationship is systemcertificationid from both the tables.

we need to select the list from last year 2013 and update like in the same query but current year 2014

Using these two querys

Select * from SNLunchSevereNeeds Where SystemCertificationID in(

Select SystemCertificationID from SNSystemCertification where FiscalYear=2014 and

SystemID=749 And IsActive=1 )

Select * from SNLunchSevereNeeds Where SystemCertificationID in(

Select SystemCertificationID...