SELECT PersonId,
       Note,
       Amount
FROM Table1 A
WHERE A.PersonId = @PersonId

UNION

SELECT PersonId,
       Note,
       Amount
FROM Table2 B
WHERE B.PersonId = @PersonId

UNION

SELECT PersonId,
       Note,
       Amount
FROM Table3 C
WHERE C.PersonId = @PersonId

SELECT * FROM
(
SELECT PersonId,
       Note,
       Amount
FROM Table1 A

UNION

SELECT PersonId,
       Note,
       Amount
FROM Table2 B

UNION

SELECT PersonId,
       Note,
       Amount
FROM Table3 C
) A
WHERE A.PersonId = @PersonId