20 Feb
2012
20 Feb
'12
2:21 p.m.
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?
--
Mark Rogers // More Solutions Ltd (Peterborough Office) // 0844 251 1450
Registered in England (0456 0902) 21 Drakes Mews, Milton Keynes, MK8 0ER