fenway

You mean like a JOIN?

Huh?

Turn on logging, check which user.

INSERT INTO...SELECT WHERE...

Use code tags next time.

If you're referring to a db wrapper class, then must be hundreds.

Best way is to use the mysql commands directly, if you can connect to both with the same user.

And there is no such thing as urgent free help.

I don't follow -- are you saying that mysql is giving you the correct results, but you just want to format to output differently?

I actually despite the omission of the AS for specifying aliases -- too error-prone.

Please don't store formatting the in the DB -- as tempting is it may be.

Then post the solution.

If it's really comma separated, you can cheat with FIND_IN_SET().

And you're NOT aware of the dangers if you're even considering this.

Why?

Replication is built into mysql.

Post your CREATE TABLE syntax.

Are you sure the columns are identical?

There is no ==.

Echo the actual query.

You can't use * and GROUP BY.

That's correct -- you can't use aggregated expressions for user-variables, since they are calculated per-row in the SELECT list. You can always try wrapping the entire thing in "SELECT * FROM (....)" to trick mysql.

You can use user variables to keep counters.

I'm sure i have references to such articles somewhere -- i'll dig around.

Still seems like a long time.