Hello everyone,
I am looking to create a query that adds a new field to the resulting table. The field should be 'Yes/No' and for every entry the default should be 'Yes'. The query looks something like this:
Select .*, [here the new field]
From MyTable1
Union
Select .*, [here the new...