fenway

I have no idea what this means. And that's quite enough bumping.

And why can't you use an ORDER BY / LIMIT?

Still confused... why 2 statements/

You sure that's the query?

Really? Don't bump then marked "solved" without at least posting the solution....

Why do you have mixed collations to begin with?

Say what? SQL has no concept of "next".

Basically any time you use an expression.

Use INET_NTOA().... what's the problem?

Huh?

Show us the final sql statement.

You'd have to send the cookie in the headers... this is SO not a mysql question.

with Group_concat()... but I'm not sure what you're trying to accomplish.

Please, share your solution.

TLDR... does the query produce the desired output? Also, "DISTINCT *" is meaningless.

What "doesn't work" about it?

That would explain the double-quotes in the other post...

That's because you have an inequality in your "join" condition!!!

SELECT "TEST RE Values Dim"."Queue Name" saw_0 , "TEST AHT By Agent"."Agent ID" saw_1 , "TEST AHT By Agent"."Transaction Time" saw_2 , "TEST AHT By Agent"."AHT -OM" saw_3 , "TEST AHT By Agent"."Number Of OM" saw_4 , "TEST AHT By Agent"."AHT -OM" / "TEST AHT By Agent"."Number Of OM" saw_3_div_4 FROM System_TEST WHERE "TEST RE Values Dim"."Queue Name" LIKE 'Queue 1' ORDER BY saw_0, saw_1 Spaces in table/field names is a bad practice. and I'm assuming you have ansi mode enabled to be able to use those double-quotes.

I don't actually see a mysql COUNT() function anywhere, either.

There must have been countless examples on this very topic on this board... and that link is even in one of the stickies. Glad you figured it out.

No, phpmyadmin won't give you an ALTER "diff" that you can run.

Why are you using different variants here --- one for the match and one for the score?

First grab the most recent of each, and THEN deal with getting the rest of the details.

Then share.