Joining to Another Table

ListManager allows you to join its members_ table to another table in your database or to any database ListManager 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 to a segment which joins to other tables, you may merge in information about members contained in those tables.

To join to another table, you must have a key for each member in your ListManager members_ table which corresponds to a primary key in your table. Joining on non-unique fields (such as email address) will likely cause duplicate results to be returned, which will cause many problems.

See SQL Guidelines for more information about how to create your own SQL queries in ListManager.

In the following example, members have been imported into the ListManager 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 ListManager should join its members_ table to in Join Other Tables. Example:

demographics

4. (Optional) Enter Columns to Display from your table that you would like displayed in your test results to verify your segment worked. 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 ListManager members_ table and any additional query. Example:

demographics.id = UserID_ AND city='Boston'

8. Click save and test.