SELECTING ALL FIELDS FOR A UNION QUERY

[jeanne]

Hi dumb question...
I have two queries... same fields ... different dates... trying to put into
a union query...Is there away to get all the fields in the query without
typing all the field names?

 

[Ken Snell [MVP]]

SELECT TableOne.*
FROM TableOne

UNION

SELECT TableTwo.*
FROM TableTwo;

 

[dtoney]

Ken,

Is this placed in the query? Or do you place the code in a VB module?