Problem joining two tables in MySQL
its resourseId in your table definition and you are using resourceId in query. 

This will work

SELECT e.resourceName FROM resources_in_room r join resource e on r.resourseId = e.resourceId where r.roomId=2;