Re: query multiple tables with identical column names

Tech-Archive recommends: Fix windows errors by optimizing your registry

David ,
I did a little experimenting and got it working, thanks for your time and
knowledge.
Dan S

Dsperry101 wrote:
David,

Is the query a single query ? I tried this :

SELECT DPGid , Description , PostLocation , SerialNumber FROM tbl113 ,
tbl114 , tbl115 UNION ALL;
got an error
Use a UNION ALL query (or a UNION query).

[quoted text clipped - 14 lines]
Thanks in advance
Dan S


--
Danny C. Sperry

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200710/1

.