compare columns matching decrypted values in different tables with different encryption types
example:
table 1 = person
column = person_id (encrypted with rijndael)
column = name
table 2 = address
column = address_person_id (encrypted with hash)
column = address_line_1
I want to search for a name in table 1 in the results page would show the persons name and address from table 2. The encrypted database values would be different, but the decrypted values would be the same. How can I do this?