Compare data from 1 table with another - Help Please

[widget]

I have 2 tables

 

One called members2 and one called members_profiles2

 

Both contain the field name "username"

 

the mp2 table has over 1000 extra records than the m2 table.

 

How do I create a comparison script that will...

 

Check the usernames in mp2 and compare them with m2 and display the usernames left over?

 

Its the left overs that I need to delete.

 

Thanks for any help.

 

php and MySQL

[widget]

Any ideas please? Im desperate to get it done tonight

[widget]

no takers?

[cags]

SELECT *
FROM members_profiles2
WHERE username 
NOT IN (
SELECT username
FROM members2
)

 

EDIT: Just realised you want to delete. Use this to check you get the right values then use DELETE.