---------BROKERAGE RECEIVED IN LAST YEAR
select * from T201819.DBO.BROKERAGE_ADDLESS_DETAIL where paysrno COLLATE DATABASE_DEFAULT IN (
SELECT PaySrNo FROM T201920.DBO.BROKERAGE_ADDLESS_DETAIL WHERE BrokSrNo='000031')