USE T202223

SELECT * FROM T202021.DBO.SUPPLIER_MASTER WHERE SUPPCODE='20CA008'

SELECT * FROM T202122.DBO.SUPPLIER_MASTER WHERE SUPPCODE='20CA008'
SELECT * FROM T202223.DBO.SUPPLIER_MASTER WHERE SUPPCODE='20CA008'

--SELECT DISTINCT TCode1, TCode2, TCode3 FROM TblRecdMainFinal ORDER BY TCode3, TCode2, TCode1