Is there a way of appending a subset of the columns from one query into another? As far as I can see the Append function only really works when the two queries have the same number of columns. When this isn't the case, for example when the table that is being appended from has more columns than the table that is being appended to, new columns are created with null values for rows in the appended to table. Corresponding columns also have to be in the same order in each query.
Neither of these conditions fits my data. What I would like to do is select the columns that I would like to append from and select the columns that they are appended to, with no requirement that all columns from the append from table have to be used. Can this be done?
2 posts • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 4 guests