Two-table query

[filburt1]

mysql> describe wdf_sotm_entry;
+-----------------+---------------------------------------+------+-----+---------+----------------+
| Field           | Type                                  | Null | Key | Default | Extra          |
+-----------------+---------------------------------------+------+-----+---------+----------------+
| entryid         | int(10) unsigned                      |      | PRI | NULL    | auto_increment |
| userid          | int(10) unsigned                      |      | MUL | 0       |                |
| month           | int(2) unsigned                       |      |     | 1       |                |
| year            | year(4)                               |      |     | 1970    |                |
| approvalstate   | enum('pending','approved','rejected') |      |     | pending |                |
| sitename        | varchar(255)                          |      |     |         |                |
| siteurl         | varchar(255)                          |      |     |         |                |
| sitedescription | mediumtext                            |      |     |         |                |
+-----------------+---------------------------------------+------+-----+---------+----------------+
8 rows in set (0.19 sec)

mysql> describe wdf_sotm_vote;
+---------+------------------+------+-----+---------+-------+
| Field   | Type             | Null | Key | Default | Extra |
+---------+------------------+------+-----+---------+-------+
| userid  | int(10) unsigned |      | PRI | 0       |       |
| entryid | int(10) unsigned |      |     | 0       |       |
+---------+------------------+------+-----+---------+-------+
2 rows in set (0.08 sec)