The SQL structure is posted below. There are 7 entries in the PageType table, that represent 7 possible types of pages. In the Page table there is 1-7 page entries per excercise ID. I need to get a list of excercise IDs (perferably names also) that do not have an entry in the page table for each of the 7 page types. This must run in MySQL 3.23.56. Excercise Field Type Null Default excerciseID varchar(32) No excerciseName varchar(255) No moduleID varchar(32) No Page Field Type Null Default pageID varchar(32) No pageName varchar(255) No pageTypeID varchar(32) No excerciseID varchar(32) No PageType Field Type Null Default pageTypeID varchar(32) No pageTypeName varchar(255) No
## Deliverables
1) Complete and fully-functional working SQL statement in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
This must run in MySQL 3.23.56.