files.md5 is the integer id corresponding to the text md5s.md5, so the above SQL will return nothing.

Said another way...

select files.path,md5s.md5 where files.md5=md5s.id;
[download]

returns a list of every file with it's MD5 sum.