What is the best method to encrypt a column that exists in two tables (BUID) in two different database on a 2012 server, at the end should be able to join on the encrypted columns between two tables across databases.
create table table1
Create table table2
basically want to encrypt the BUID in both tables and be able to crate a view that joins across two databases.
create view vw_cust_balance
from testdb1..table1 a inner join testdb2..table2 b
on a.buid = b.buid
Can someone point me to a resource or example that resolves situation above.