Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Other Forums  MS Access  Value for each nodename at max time

Author  Topic  bobm Starting Member 1 Post Posted - 2010-01-19 : 22:27:34 I need to find a value for each nodename where the time is maximun for each nodename. Its an access passthrough query to MYSQL. Three tables: nodes, variables and variablelog. Any suggestions for altering the code below? SELECT nodes.nodeName, variables.varName, variablelog.value, from_unixtime(variablelog.time) FROM variablelog LEFT JOIN (variables LEFT JOIN nodes ON variables.nodeId = nodes.nodeId) ON variablelog.varId = variables.varId WHERE variablelog.time > (UNIX_TIMESTAMP() - 400200) ORDER BY nodes.nodename DESC;