SELECT Table1.Field1, Table2.Field2 ; FROM Table1, Table2 ; WHERE Table1.Id = Table2.Id ; UNION SELECT Table1.Fiedl1, SPACE(10) ; FROM Table1 ; WHERE Table1.Id NOT IN(SELECT Id FROM Table2) ; INTO CURSOR MyLOJThe SPACE(10) is aplace holder for the fiedl from table2. It must be the same size and data type as the field in table2.