>This looks like a case where a FULL OUTER JOIN might be required. I also hope he doesn't end up with a huge number of extra fields, then the SQL doesn't work so well.
Gordon,
You're right a table might not have each field for every id + other fields. That's why I said "I wouldn't try to do this with SQL. Anyway for only 2 fields as in your sample :"
Cetin