var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query query
How do I query a table of Dates, so that only the row with the most recent date is returned?
Using SORT is not an option.
I see no other way than that. Or you add an auto-increment column and select the highest entry.. ?
What's wrong with sorting by date and using limit 1 ?
It's actually part of a JOIN that I'm trying to create.
I want to join 2 tables where the row with the most recent date from Table_A is joined to row(s) from Table_B.
I cannot use SORT or LIMIT on Table_A because that would mean I would be trying to use a subquery as one of the JOIN parameters, which you cannot do in mySQL.
I'm trying to avoid a 2 step query if possible (also trying to flex my brain a bit!) My last resort at the moment is to use a temporary table.
I'm curious to know if there is a method of doing it in 1 step though.
(I might be wrong in everything I've said above!)