 <p>i didn't completely understood what you are trying to do... but i think that you want to do is to list all the entities including the date of their last modification.. if that's it, you could use a GROUP BY, and a MAX() function like this</p> <pre><code>SELECT e.title,e.body,MAX(r.revised) FROM `entities` e JOIN `revisions` r ON r.entity_fk = e.id GROUP BY e.title,e.body </code></pre> <p>BTW.. i'd change the name of "entity_fk" to "entity_id", its kinda confusing.. at least for me =)</p>