Joining tables

[Guest]

Can a table be joined with itself?

 

[Guest]

If what you mean is to add the table twice to a query and join it to itself,
then yes, you can do it, personaly I can't see the point for that.

But you can add the same table few times to the query.

 

[Guest]

That's it! Thanks!

If what you mean is to add the table twice to a query and join it to itself,
then yes, you can do it, personaly I can't see the point for that.

But you can add the same table few times to the query.

 

[Larry Linson]

then yes, you can do it, personaly I
can't see the point for that.

But you can add the same table few times to the query.

Three examples where this would be useful:

1. Bill of Materials processing where
assemblies are made of subassemblies,
which may in turn be made of either
subassemblies or parts -- all kept in
the same table

2. A genealogy database, where each
person refers to the key of both
parents' entries -- where all people
are kept in the same table.

3. A company hieriarchy, where each
person's record identifies that person's
manager -- all "people" in the company
are kept in the same table.

Larry Linson
Microsoft Access MVP

 

[Guest]

Thanks. it good to know

Three examples where this would be useful:

1. Bill of Materials processing where
assemblies are made of subassemblies,
which may in turn be made of either
subassemblies or parts -- all kept in
the same table

2. A genealogy database, where each
person refers to the key of both
parents' entries -- where all people
are kept in the same table.

3. A company hieriarchy, where each
person's record identifies that person's
manager -- all "people" in the company
are kept in the same table.

Larry Linson
Microsoft Access MVP