I have two tables from two different databases. both connected with Date table, but these two tables has no direct relationship.
table 1 from sales database, table 2 from contact and leads database.
both tables have email columns which are actual buyer’s email and prospect buyer’s email. I am trying to compare these two email columns and see how many emails are matching, and count this number, then calculate the percentage of the count out of sales, so i will know eventually how many prospect buyer turn into a real buyer over time.
I am looking for a best way to achieve this, thank you for the help!
Thank you in advance!