I've got two tables which I need to have sorted into a single query.
One of the tables contain "static" data while the other one is a rolling log of status and uptime and from there only the last result is needed for every entry in the first table.
So basicly ..
and then ..
SELECT MAX(id) as entryID,
and then somehow magicly have the result come out as single rows per server.id
How's that done? I've tried all kinds of different joins but can't get it working.