Joining A Table

The Create Subset (Simple) page allows you to make subsets based on data which is in the ListManager members table. If you'd like to make a subset based on data in another table, you may use the Create Subset (Advanced) page to join to any table to which ListManager has access.

For example, let's say you have a table named Customers in the ListManager database which has four columns: CustomerID, Email, Sex, Country. The CustomerID is the same as the ListManager MemberID_.

To select only those customers who live in France, you'll need to join your Customers table to the ListManager members table using the Create Subset (Advanced) page. To do so:

1. Log in as a List Administrator.

2. Click on Subsets.

3. Select Create Subset (Advanced).

4. For Name, enter France.

5. For Description, enter Customers who live in France.

6. For Columns to display for testing, enter Email, Country. These two columns will appear when you test the subset.

7. For Join other tables, enter Customers, the table which contains the information about your customers.

8. For Additional SQL "WHERE" Criterion, enter

CustomerID = MemberID_ and Country = France

9. Leave Sorting blank.

10. Leave Max Records at 50.

11. Click on Save and Test.

The Test Subset page will show your SQL query, and the first 50 records which meet your WHERE criteria. In this case, the addresses selected would be those ListManager list members who are also in your Customers table and are from France.

Which table you join, and the WHERE criteria you use to join to it depends on the structure of your database. Consult your database administrator for more information about your database, its permissions, and how to best join the ListManager members table to your own tables.