---

SELECT d.Nomer_Dogovora
FROM Dogovor_Arendy d
JOIN Klient k ON d.Kod_Klienta = k.Kod_Klienta
WHERE k.Familiya = N'Иванов' 
  AND k.Imya = N'Иван' 
  AND k.Gorod = N'Ярославль';