Help with a SQL statement (resolved)

[TysonLPrice]

I'm not very good with SQL, I only know basic selects. I have a data corruption issue that I saw on-line and need to identify if there are more cases of it. I have two tables.

Table one uses the keys:

ClaimID and RequestID

Table two uses the keys:

ClaimID, RequestID, and DocumentID

The ClaimID should always be the same in table one and table two. I need to identify any instances where the RequestID in table one and table two are equal but the ClaimID is not.

I've played around with different combinations of joins but I'm not having any success...getting frustrated.

Any takers?

* Never mind - I was making it too difficult - I got it *