I have a three level self-join that is working fine. This query uses the same table, A, three times.
I'd also like to add another field from another table, B, to the output of the self-join query. Tables A and B can be joined on a field. I tried to create a query, qryC, joining tables A and B and do a self-join on qryC but it's not working.
I'd appreciate any help in accomplishing this.