Yes, I'm totally with you Graham and I have created your tables and
added some test data (you saw it in a previous post).. But I can't seem
to come up with any solution for you, at least with MySQL 4.0.x.
So if no one else has any brilliant solutions for this I think you'll
need to stick with
Hi!
You can't use the MAX() function if you're not using a GROUP BY clause.
The MAX() function can only grab the maximum value of a grouped column,
as with MIN(), COUNT(), AVG() etc..
Greetings,
Krister Karlström, Helsinki
Jonathan Crawford wrote:
I think this is what you mean. You just wan
On Fri, Mar 7, 2008 at 12:27 AM, Jonathan Crawford <[EMAIL PROTECTED]> wrote:
> I think this is what you mean. You just want the timestamp and action from B
> in addition to something from A (I guessed product_ref), right? The MAX()
> function should take care of getting the latest timestamp.
>
