Allen Pitts
asked on
Component is listed with a Protocol more than once
The table Protocol_Component has fields:
PROTOCOL_COMPONENT_ID
PROTOCOL_ID
IS_DISABLED
COMPONENT_ID
OWNER_ID
OWNER_TYPE_CODE
Need to develop a list of Protocols and Components
where a Component is listed with a Protocol more than once.
Thanks.
Allen in Dallas
PROTOCOL_COMPONENT_ID
PROTOCOL_ID
IS_DISABLED
COMPONENT_ID
OWNER_ID
OWNER_TYPE_CODE
Need to develop a list of Protocols and Components
where a Component is listed with a Protocol more than once.
Thanks.
Allen in Dallas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
from your_table
group by protocol_id,component_id
having count(*) > 1