query im multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

my database possesses vary tables with the same fields, how to consult in all
at the same time

ex: ba.comutacao rj.comutacao ba.comutacao
 
multiple tablles said:
my database possesses vary tables with the same fields, how to consult in all
at the same time

ex: ba.comutacao rj.comutacao ba.comutacao
Click to expand...

You should reconsider this design: it is NOT good practice. Storing data in
tablenames (as you seem to be doing) makes searching much more difficult! You
should consider creating *one* table, with one additional field (perhaps for
your current table names), and running Append queries to move your data into
this one table.

If you are unable to do this, you can use a UNION query to connect all these
tables together. See UNION in the online help; you will need to build the
query in the SQL window.

John W. Vinson/MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACC2K3: Multi-table Update Transactions Are Unreliable 11
Access Dcount (multiple criteria) 3
Query from differnt tables 4
Same record/Primary key in multiple tables 0
Consult to Insert Data 4
Assign price category based on multiple record criteria 9
Custom Alpha/Numeric Autonumber 12
Database design/ tables design 1

Back
Top