--- Original Message ---
From: "Joshua J. Kugler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sun, 07 Mar 2004 04:57:30 -0900
Subject: Re: Selectinmg most recent dates from multiple table items
> SELECT DISTINCT sensor_id, other_fields FROM table_name
> ORDER BY
SELECT DISTINCT sensor_id, other_fields FROM table_name
ORDER BY time_stamp_field DESC LIMIT 40
Not sure if that will work, but does it point you in the right direction?
j- k-
On Saturday 06 March 2004 07:22 pm, Tim McDonough wrote:
> On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote
On Sat, 06 Mar 2004 20:40:24 -0600, Paul DuBois wrote:
>
> You can use your LIMIT clause as well, as long as by that you don't
> mean "5 most recent from *each* table".
>
This seems similar to something I'm working on which I haven't sorted
out to my satisfaction yet.
We have a system that colle
