Joining several terms into one table?
I have the following table:
   
    GENRES
    gID | gNAME
    1   | Fiction 
    2   | Non-Fiction
    3   | Comedy
    4   | Horror

And this table

   PRODUCTS
   pID | pNAME 
   1   | 4 hour work week
   2   | screw it let's do it

And then the assign table:

   ASSIGNTABLE
   aID | pID | gID
   1   | 1   | 1
   2   | 1   | 2
   3   | 2   | 2
   4   | 2   | 3
   5   | 2   | 4

I need a query that will return the following:

   pID | pNAME                 | pGENRE
   1   | 4 hour work week      | Fiction
   2   | screw it let's do it  | Non-Fiction


In other words, I need to ONLY get ONE genre per product. How do i do this?
Joining several terms into one table?
===

I have the following table:
   
    GENRES
    gID | gNAME
    1   | Fiction 
    2   | Non-Fiction
    3   | Comedy
    4   | Horror

And this table

   PRODUCTS
   pID | pNAME 
   1   | 4 hour work week
   2   | screw it let's do it

And then the assign table:

   ASSIGNTABLE
   aID | pID | gID
   1   | 1   | 1
   2   | 1   | 2
   3   | 2   | 2
   4   | 2   | 3
   5   | 2   | 4

I need a query that will return the following:

   pID | pNAME                 | pGENRE
   1   | 4 hour work week      | Fiction
   2   | screw it let's do it  | Non-Fiction


In other words, I need to ONLY get ONE genre per product. How do i do this?