Using a table more than once in a query

  • Thread starter Thread starter Adam
  • Start date Start date
A

Adam

Access 2000 seems to be quite happy to let me use the same table more than
once in a single query. It simply appends '_1' to the table name for the
second time it is used, '_2' the third time it is used, and so on.

Is this something specific to Access, or is it part of standard SQL? Is
there anything I need to beware of if I'm using this syntax?

Many thanks
 
If doing this I would make use of the AS keyword so that it is easier to
identify which instance of the table you are referring to.

HTH
 
Dear Adam:

If you provide your own alias for the table, then I don't think it
will do this. However, it is essential that each instance of a table
be distinctly referenced.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Many thanks to both Tom and Newbie. Defining my own alias for the table
sounds like a much better idea.

Adam
 

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

Access 2010 append query to SQL is very slow 0
When queries fire more than once 7
Limit action query 1
Append Query Issue 0
Using query to make a table 3
Combine Duplicates in Query 0
Using more than one join in a query 1
Append Query To Table 3

Back
Top