I often encounter such a problem. There are two tables sharing the same
key ID, but they do have different num of records. But some of records
do not appear in another table. I need to merge them into a whole table
with all fileds where the missing values are replaced by blank or N/A.
ID Name Phone
1 Andy 111
BTW, Excel provides SQL support, so I thought I could use FULL OUTER
JOIN Syntax to do this.