Good Day All.
Can anyone tell me if is possible to combine two tables with similar fields, in a query, without actually combining the tables. The tables would appear like if they are union, but in actually fact the tables remains separated. I don't want to create a third table from the combined tables.
Can anyone tell me if is possible to combine two tables with similar fields, in a query, without actually combining the tables. The tables would appear like if they are union, but in actually fact the tables remains separated. I don't want to create a third table from the combined tables.