Selecting SQL data

The data selection and query process are the same for both EDM/SQL and PostgreSQL databases.

1. First select the tables you want to query:
   • Linked Tables—tables linked by the Primary Key
   • Un-Linked Tables—tables that do not contain the Primary Key

2. Now create the Well Query:
   1. Attributes fall into 3 categories: Categorical Data, Numerical Data, and Dates. Expand each category and select the attributes you want to query for.
   2. As each attribute is selected, the named items for the selected attribute are listed to the right.
   3. Select the named attribute(s) and click Add to move them to the query box on the right.
   4. The query box lists all criteria and displays the number of records that contain that criteria out of the total.

3. When your query is complete, click Load.