I cant seem to figure out how to join these two table to execute and return all I need in one payload through a single query. Any Help would be very appreciated.

As you will see everything work with the first half of the query if I place a ; at the end of the closing parenthesis following the "IN".

However when I go to join this table with another table propA\_Photos, MySQL throws and error. I only want the propA\_Photos.photo column joined with the above in one query.

What am I doing wrong?

```
SELECT propA.list_id, propA.list_key, propA.list_value
FROM propA
where list_id = '20141118214124325535000000'
    AND list_key IN ('LIST_1', 'LIST_22', 'LIST_33', 'LIST_31', 'LIST_34', 'LIST_35', 'LIST_36', 'LIST_37', 'LIST_39', 'LIST_40', 'LIST_43', 'LIST_41', 'LIST_46', 'LIST_47') 
INNER JOIN propA_Photos.photo;

```