עדכון תאריך סיום מנוי לפי תאריך עזיבה

UPDATE tashlum SET tashlum.thov_ad = kore.aziva FROM kore WHERE tashlum.thov_ad > kore.aziva AND kore.semel = tashlum.kore SELECT * FROM kore WHERE aziva IS NOT NULL