/* Mismatching Photo File Name & Signature File Name b/w 2021 & 2020 */
SELECT C2021.ID, C2021.Name
, C2021.FileName AS Photo_21, C2020.FileName AS Photo_20
, C2021.SignatureFileName AS Sign_21, C2020.SignatureFileName AS Sign_20
FROM COS_2021.dbo.Customers C2021
INNER JOIN COS_2020.dbo.Customers C2020 ON C2021.ID = C2020.ID
WHERE (C2021.FileName <> C2020.FileName) OR (C2021.SignatureFileName <> C2020.SignatureFileName)



/* Accounts dont have Interest Details in 2016-17 & 2017-18 */
SELECT AccountNo, EntryDate, Due_Maturity_Date FROM Accounts
WHERE (IsClosed = 0 OR IsClosed IS NULL)
AND AccountTypesID IN (SELECT ID FROM AccountTypes WHERE FormType = 'FD Form')
AND AccountNo NOT IN (SELECT AccountNo FROM Accounts_Interest_Details)
AND Due_Maturity_Date >= '20160401'
ORDER BY AccNo
GO


/* Interest not used in 2016-17 & 2017-18 */
SELECT * FROM Accounts_Interest_Details WHERE IsUsed = 0
AND AccountNo IN (SELECT AccountNo FROM Accounts WHERE (IsClosed = 0 OR IsClosed IS NULL)
AND Due_Maturity_Date >= '20160401')
AND InterestDate <= '20160331' 
GO


/* InterestPaymentType = 'On Maturity'*/
SELECT AccountNo, InterestPaymentType FROM Accounts WHERE 
InterestPaymentType = 'On Maturity'
AND (IsClosed = 0 OR IsClosed IS NULL)
AND AccountTypesID IN (SELECT ID FROM AccountTypes WHERE FormType = 'FD Form')
GO