N
NuStudent
Can a table be joined with itself?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
Ofer
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.
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.
N
NuStudent
That's it! Thanks!
Ofer said: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.
L
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
O
Ofer
Thanks. it good to know
Larry Linson said: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