G
Guest
I have two tables with the same structure. One is an archive of records from
the other, but there is an occasion where both need to be searched for an
item that may have been overlooked, after the records have been archived. Is
it possible to create a query that will join the two tables, so the tables
appear to be one without a difference in column names (without table
qualifiers)?
the other, but there is an occasion where both need to be searched for an
item that may have been overlooked, after the records have been archived. Is
it possible to create a query that will join the two tables, so the tables
appear to be one without a difference in column names (without table
qualifiers)?