HELP HELP with a problem.

I am looking to do some sort of content promotion tool for a site that I am working on. Now I am doing this, because the people who are running it know nothing about databases, or exports or anything like that, so I though I would make it easy for them. So anyway what I have is a "staging" database and a "production" database, now some tables need updates and inserts, some tables need inserts and some can just blow away the table and go from there. I am starting with the hardest one, this one carries data that is different from production and stage. So the production data in certain fields cannot be touched. So my thought is to compare the two tables, and of course on stage there will be more, so I grab the ids of the ones that are missing on production from stage and write the insert statement, after that is done I then run the update sql to turn the correct data online. Okay there are other pieces, but where I am having troble is doing the compare, I want it to look at stage and say I have 5 rows, and look at production and say I have 2 rows, now it will say get the ids from stage that dont have counter parts on production. Any thoughts ???? thanks __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com