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
 
Back
Top