Custom SQL Query

Advanced users can query the CC8 Phase 4 database using Structured Query Language(SQL). Only read-only (Select) queries are allowed. In formulating SQL queries, refer to the Table Map and Table Details. Note that queries requesting a large amount of data may overload the system and will be rejected.


Table Map

The database is organized into 9 tables as shown in the figure below. Key fields in each table are unique identifiers and are indicated by a key symbol. Lines represent links between tables. To view sample queries select the Sample Queries link.



Return to Search CC8  Phase 4  Database

SQL Query Dynamic Data
Enter SQL statement: