mcfarlandparkway (12/18/2013)

---

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 from SNSystemCertification where FiscalYear=2013

And IsActive=1)

How can I update data from last year to current year (need to check system certification id from both the tables)

see the current fiscal year for all the systems who are eligible.(updating from last year to current year)