bluefoxoctober
IS-IT--Management
When running queries on three or more tables, I often get the join conditions to work on the first two tables, but not on the third or fourth tables. This causes the output to have multiple selected records for the first table, and the number of multiples is equal to the number of selected records from the third or fourth tables. I can fix it by running two separate queries, but I need to be able to turn this process over to users, and their skills are somewhat limited.