--WHERE CredOperNumber = 341378
    WHERE CLAIM.ClaimDate > '2019/11/13'
    order by claim.ClaimDate

SELECT CredOperNumber, Did, Tid, ClaimNumber, ClaimTypeCid
    FROM CredOper
    JOIN Claim ON Claim.CredOperDid = CredOper.Did
    --WHERE CredOperNumber = 341378
    WHERE CLAIM.ClaimDate > '2019/11/13'
    order by claim.ClaimDate