Re: nested select statement syntax error

[Peter Brawley]

Something like ...

SELECT ABS(t1.recv-t2.recv) AS Diff
FROM tbl AS t1
INNER JOIN tbl AS t2 ON t1.timestamp = t2.timestamp - INTERVAL 5 MINUTE
ORDER BY Diff DESC
LIMIT 1;

?

PB