/*
1- 2020 deki CEK tablosundan ISLEM No alanı 2022 CEK Tablosuna aktarılacak where şartı çekno ve Protfoyno 2020 için teminatta
update Ent_NARGAZ2022.dbo.BANKA set ISLEMNO=BANKA2020.ISLEMNO FROM Ent_NARGAZ2022.dbo.BANKA AS BANKA2022
INNER JOIN Ent_NARGAZ2020.dbo.BANKA AS BANKA2020 ON BANKA2020.PORTFOYNO=BANKA2022.PORTFOYNO AND BANKA2020.CEKNO=BANKA2022.CEKNO
WHERE BANKA2020.CEKDURUM='Teminatta' AND Ent_NARGAZ2022.CEKDURUM='Teminatta' 
*/
----BUUPDATE ÇALIŞNCA CEKLER TAHSIL OLUYOR
UPDATE Ent_NARGAZ2022.dbo.CEK SET ISLEMNO=CEK2020.ISLEMNO,BORDRONO=CEK2020.BORDRONO
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
INNER JOIN Ent_NARGAZ2020.dbo.CEK AS CEK2020 ON CEK2020.PORTFOYNO=CEK2022.PORTFOYNO AND CEK2020.CEKNO=CEK2022.CEKNO
WHERE CEK2020.CEKDURUM='Teminatta' AND CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (SELECT CEKNO FROM Ent_NARGAZ2022.dbo.CEK WHERE CEKDURUM='Teminatta' )

--SELECT CEK2020.ISLEMNO,CEK2022.ISLEMNO AS ISLEMNO_,* 

UPDATE Ent_NARGAZ2022.dbo.CEK SET ISLEMNO=CEK2020.ISLEMNO
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
INNER JOIN Ent_NARGAZ2020.dbo.CEK AS CEK2020 ON CEK2020.PORTFOYNO=CEK2022.PORTFOYNO AND CEK2020.CEKNO=CEK2022.CEKNO
WHERE CEK2020.CEKDURUM='Teminatta' AND CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (2022882,4882,5516556)

SELECT BORDRONO,BORDRONO2,* FROM  Ent_NARGAZ2022.dbo.BANKA AS BANKA2022 
WHERE BANKA2022.ISLEMNO IN (
SELECT ISLEMNO
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
WHERE CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (2022882,4882,5516556))

SELECT BORDRONO,BORDRONO2,* FROM  Ent_NARGAZ2020.dbo.BANKA AS BANKA2022 
WHERE BANKA2022.ISLEMNO IN (
SELECT ISLEMNO
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
WHERE CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (2022882,4882,5516556))

SELECT *   
FROM Ent_NARGAZ2022.dbo.CEK AS CEK2022
INNER JOIN Ent_NARGAZ2020.dbo.CEK AS CEK2020 ON CEK2020.PORTFOYNO=CEK2022.PORTFOYNO AND CEK2020.CEKNO=CEK2022.CEKNO
WHERE CEK2020.CEKDURUM='Teminatta' AND CEK2022.CEKDURUM='Teminatta' 
AND CEK2022.CEKNO IN (2022882,4882,5516556)



select BORDRONO,BORDRONO2,* from BANKA where BORDRONO = 840 and BORDRONO2 = 1081