select g.name,scrnshotfilename,publisher,ye_id,genre from games g inner join Genres p on g.ge_id = p.ge_id inner join publishers t on g.pu_id = t.pu_id where g.name = 'guess'

is working...

I have no issue with the text strings, it's the SQL query that's not working. The data is in Access.