Properly drafted my query to mysql in combination of join and orderby?

Properly drafted my query to mysql in combination join and the orderby in the plan is optimal if such a request including speed, etc. I just don't quite understand how it would work logically at what the table is sorting, or both, perhaps it should somehow separately ask?
SELECT * FROM blogs JOIN comments ON comments.id = blogs.id ORDER BY title DESC
July 9th 19 at 13:19
1 answer
July 9th 19 at 13:21
Solution
Specify the names for each table
SELECT blogs.*, comments .* FROM blogs JOIN comments ON comments.id = blogs.id ORDER BY blogs.title DESC

Find more questions by tags MySQLPHP