I may have missed the point, but it looks like you might be wanting to use a UNION rather than a JOIN since you just want to query multiple tables rather than join anything together.

See http://dev.mysql.com/doc/refman/5.4/en/union.html

Aside: whether you know it or not, by separating the tables by commas as you have, you're already doing an INNER JOIN on those tables.