Kirix Strata Blog

Archive for the ‘relationships’ Category

Using Relationships to Compare Lists of Emails

Thursday, July 31st, 2008

In a previous article, we were concerned with identifying and removing duplicate emails within a single table.  But let’s say that email addresses are located in multiple tables — how do we find which email addresses are duplicated in both lists?

To answer this question, we have to break out one of Strata’s more powerful features called relationships.

In Strata, relationships allow you to match records in one table with records in another table based on a common value.  In this example, the common value is a specific email address found in both tables.  For instance, let’s suppose we have two lists of email addresses stored in two tables, email_list1 and email_list2.

In email_list1, we have the following values:

email_list1
--------------------
second@email.com
third@email.com
fourth@email.com
fifth@email.com
sixth@email.com
seventh@email.com

(more…)