Subquery and JOIN's

[Jason Heddings]

I have the following layout in 2 tables:

data => id, owner, time, value
owners => id, name

I'm trying to create a query to get the most recent update in the `data` table and return the name in the `owners` table with the value. To get the most recent update for each owner, I have the following query (which seems to be working well):

SELECT * FROM (SELECT * FROM `data` ORDER BY `time` DESC) d1 GROUP BY `owner`;

Now I'm having trouble creating the statement to add the owner name to the result. I attempted the following statement, but it does not seem to work:

SELECT * FROM (SELECT * FROM (SELECT * FROM `data` ORDER BY `time` DESC) d1 GROUP BY `owner`) d2, `owners` WHERE (d2.owner = owners.id);

This look terribly inefficient to me, but I can't think of another way to accomplish the same goal. I'm a bit new to SQL programming, so there may be a more sophisticated way to accomplish this. Thanks for any help!