Oracle SQL statement question

SUMMARY:

The following query is the working query that retrieves the USERID, PAGEMBR, UPD_USER, UPD_DT from the table COLOR.TAB_COLOR_CMDLINK_SECURE:

select * from COLOR.TAB_COLOR_CMDLINK_SECURE
Where USERID = '2651'
Order By PAGEMBR


The following query is the working query that retrieves the SEGMENT, SEGDESC from the tables COLOR.TAB_COLOR_SEGMENT and COLOR.TAB_COLOR_DEFS from a LIKE query, used in a GUI SEGMENT search function:

SELECT a.SEGMENT, ltrim(b.description) AS SEGDESC from COLOR.TAB_COLOR_SEGMENT a,
COLOR.TAB_COLOR_DEFS b
WHERE b.id = a.segment
AND id LIKE '%060000%'
Order by ltrim(b.description)



QUESTION:

What I need is a query that does not show the SEGMENTS that a user belongs to in results returned from a LIKE search.

Pseudocode Logic:

1. View a list of segments that a user has assigned to them in the COLOR.TAB_COLOR_CMDLINK_SECURE table. - Done (first query above).

2. Add segments to a user by searching for Segments. - Done (second query above). <-- Change: Needs to only show the segments that a user is NOT assigned to.

Any suggestions or direction is appreicated. Thank you!