# SELECT categories user has not already selected

**URL:** <https://forum.kirupa.com/t/select-categories-user-has-not-already-selected/303241>\
**Category:** programming\
**Created:** [January 17, 2010, 2:02pm UTC](https://forum.kirupa.com/t/select-categories-user-has-not-already-selected/303241 "2010-01-17T14:02:13Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![IQAndreas](https://avatars.discourse-cdn.com/v4/letter/i/f08c70/32.png) [@IQAndreas](https://forum.kirupa.com/u/IQAndreas)\
**Post date:** [January 17, 2010, 2:02pm UTC](https://forum.kirupa.com/t/select-categories-user-has-not-already-selected/303241/1 "2010-01-17T14:02:13Z")

</div>

I really have no idea how to approach this problem, or even what to search Google for.

There are a dozen or so categories that the user can choose from. The table structure is roughly like this:

> **TABLE Categories**  
> categoryID - Primary Key  
> categoryName  
> caetgoryDescription

**TABLE UserChoices**  
id - Primary Key  
userID  
categoryID - FK

Now, I want the user to be able to **view a list of all categories that he has NOT yet chosen**. Am I making myself clear? I have no idea even what way to think for that one…