Re: [ALUG] SQL question, I suspect I need some sort of inner join

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