Operation Details |
Description: | Retrieves a list of all services categories not associated with a specific service |
Sterotype: | nsmulti |
SQL |
SELECT code INTO :categoryCode FROM codetableitem WHERE tableName = :tablename AND code NOT in ( SELECT categoryCode FROM ServiceCategory WHERE serviceID = :serviceID ) |