Note: Union Query output assumes first table name.

  • Thread starter david epsom dot com dot au
  • Start date
D

david epsom dot com dot au

When using 'nested' querydefs (referring in a query to named/saved select
query/view), you can optionally qualify the field name with the TableName of
the base table, instead of using the query/view name:

SELECT Table1.idxRecord from Query1;

When the base query is a Union Query:
SELECT * from Table2
union all
SELECT * from Table3;

Access/Jet allows you to create queries like this:
SELECT Table2.idxRecord from Query2

Which is surprising.

(david)
 
Top