I am not quite able to get my query to do what i need it to do. See attatched file for query
IT NEEDS TO CHECK THE MATRIX_ITEMS.MATRIX_GROUP_CODE against the MATRIX_ELEMENT_SELECTION table.
The query needs to find all records in the MATRIX_ITEMS table that do not have matching data in the MATRIX_ELEMENT_SELECTION table based on the query limits provided above.
Next is simply needs to simply use the data returned from MATRIX_ITEMS table to delete matching items in the items table
DELETE FROM ITEMS
WHERE ITEMNO = MATRIX_ITEMS.ITEM_CODE
This all needs to be done in a sql query. should be simple for a seasoned sql pro.