I have 3 tables.

Table 1

DOC_ID

Table 2

DOC_ID
KEYWORD

Table 3

VIEW_ID
KEYWORD

I am using 3 tables to retrieve a view of data based on what the user defines.  Kind of like a speed-dial or favorite.  The user can define what "keywords" will determine what will appear in the view they define.  The first table is a list of documents in the system.  These documents can have 0, 1 or many keywords added to them.  These keywords are stored in Table 2.  The 3rd table is a list of keywords for the view the user has defined.  I have a treeview that when the user clicks on the view it retrieves a doc list on the right based on the keywords defined for the view.

The problem I am having is how to JOIN Table 1 to 2.  When I join them, it duplicates the rows from table 1 for each keyword added to table 2.  

I feel like I am missing something simple, but have been staring at this for days.

I tried building a temp table and testing each doc to see if it meets the view criteria, but there are thousands of documents and the function was incredibly slow and will not be acceptable to users.   I have also looked at "Exists".  This seems to be the way to go to do a quick retrieval, but I still get duplicates.  

Hoping someone has done a retrieval like this and can point me in the right direction.

Thanks.

Rick