mass replace of values in more tables by a highest value

Posted by nescius on Stack Overflow See other posts from Stack Overflow or by nescius
Published on 2010-06-14T18:09:22Z Indexed on 2010/06/14 18:12 UTC
Read the original article Hit count: 153

Filed under:
|
|

Hello, I have a table with OWN_ID and OWN_Email -

3ace7cf80edd    |   [email protected]
3acf6af33ff7    |   [email protected]
3acda2524e00    |   [email protected]
3ad75583c9a7    |   [email protected]
3ad74b018999    |   [email protected]

etc.

the problem is that it should contain only a single ID per Email, also I need to replace all OWN_ID values in another table by highest OWN_ID value of the OWN_Email

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql