I'm a total SQL n00b, so forming complex SQL statements is kind of new to me. I'll give your query a shot tomorrow and let you know how it goes.<BR><BR>Thanks!

The RIGHT JOIN: Matching records plus orphans from the right When you execute a query using the RIGHT JOIN syntax, SQL does two things: It returns all of the records from both tables that contain ...

Here is the SQL to compare the inner and outer JOINs: SELECT InnerOuter.T1.T1ID, InnerOuter.T1.NameAS Name1, InnerOuter.T2.T2ID, InnerOuter.T2.NameAS Name2 ...

The left join updates all rows in table A. Inner join only updates rows in table A where there is a matching ID in table B. You're working with different row sets.