Joining to another table

Aurea List Manager allows you to join its members_ table to another table in your database or to any database Aurea List Manager can access. Once you have joined to another table, you may further segment your list based on criteria contained in that other table. If you send it to a segment that joins to other tables, you may merge in information about members contained in those tables.

To join another table, you must have a key for each member in your Aurea List Manager members_ table, which corresponds to a primary key in your table. Joining on non-unique fields such as email address may cause duplicate results to be returned, which causes many problems.

See SQL Guidelines for more information about how to create your SQL queries in Aurea List Manager.

 

In the following example, members have been imported into the Aurea List Manager members_ table with the primary key for the demographics table in the members_.UserID_ field.

1. Create a new segment by clicking on the Segments tab and clicking on Create new segment.
2. Click on the Advanced tab.
3. Enter the table name that Aurea List Manager should join its members_ table to in Join Other Tables. For example: demographics
4. (Optional) Enter Columns to Display from your table that you want displayed in your test results to verify your segment worked. For example: city
5. Click on the Essentials Tab.
6. Enter a Segment Name and Description.
7. Enter the SQL where clause in Query that joins the table to the Aurea List Manager members_ table and any additional query. For example: demographics.id = UserID_ AND city='Boston'
8. Click Save and test