[RESOLVED] SQL -> Duplicated id's?

[h4x0rmx]

I'm working with a DB that was poorly designed.
I have the following fields in a table called user_main:
user_id (unique, autoincrement), user_first_name, user_last_name, user_password, user_work_id, ...

The user_work_id should be unique, but it's not... I've found a few users that have the same user_work_id
I need help creating a query to retrieve the user_id's of the users that share their user_work_id with other users, but I don't know where to start?

Any suggestions?
Any help will be really appreciated!

[h4x0rmx]

Sample data:

user_id *	user_name *		team_id *	user_fname *	user_lname *	user_work_id *
1045		edwina Weikel	 	1		edwina		Weikel 		859180386
1230		jamie Driggs		1		jamie		Driggs		859180386

This is the kind of users I need to find, they have different id's for the database, but same user_work_id which shouldn't be allowed.

[Yes, the DB's design is bad, look! user_name and then user_fname & user_lname]

[Lars_Berg]

select user_id, user_name 
  from user_main
 where user_work_id in
        (select user_work_id
             from user_main
           group by user_work_id
           having count(*) > 1)

[h4x0rmx]

@
Thanks for your help!
That's exactly what I was looking for!