You need to have a subquery to get their latest date per user ID . SELECT a.*, c.* FROM users a INNER JOIN payments c ON a.id = c. ... <看更多>

To understand the reason behind slowness of your current query, you need to understand the Nested Loop Join algorithm used by MySQL. ... <看更多>

Oct 20, 2015 - In this tutorial, you will learn how to use MySQL INNER JOIN clause to select data from multiple tables based on join conditions. ... <看更多>