20 Feb
2012
20 Feb
'12
3:41 p.m.
On Mon, Feb 20, 2012 at 02:21:00PM +0000, Mark Rogers wrote:
On 20/02/12 13:11, Chris Green wrote:
Is there an easier/better way where I join using the id which matches the minimum temperature to select the other columns I want?
Not sure this is "better" but how about:
SELECT Date, Time FROM temperatures WHERE Date like '2012%'ORDER BY Inside_Temperature ASC LIMIT 1
Would only get you one result (not one for each date that the minimum occurred on) which may be a deal-breaker?
Now that's what I call lateral thinking! :-)
I just want the minimum temperature, I'm not too fussed if it occurs on more than one date, so the above looks good.
--
Chris Green