mySQL Query Needed

[WildSeeker]

Greetings!

I need to run a query of my mySQL database, and do not wish to bother my developers with the task ... hoping somebody here can assist me with an appropriate query.

I have the following three tables:

'outfitters'
'outfitter_activities'
'outfitter_destinations'

Each record in the 'outfitters' table is to have at least one associated paired record from both the 'outfitter_activities' and 'outfitter_destinations' tables.

What has happened is that the key field ('outfitterID') that links all three of the tables has been changed in the 'outfitter' table for a number of records, without having correspoding changes made to the records in the related tables. This has resulted in many 'orphaned' records in the '_activities' and '_destinations' tables.

Most importantly, I would like to run a query that will show me all records in the 'outfitters' table that do not have corresponding records in the '_activities' and '_destinations' tables. Secondly, I would like to clean up the 'orphaned' records, so I would like to run a reverse query of the '_activities' and '_destinations' tables that will show me all records that do not have a related record in the 'outfitters' database. I hope this makes sense.

I Use phpMyAdmin to access my database.

Any help/suggestions would be greatly appreciated!