When using query builder, I get multiple records when I use Join. In The example below, I get 3x the records I expected, each record being duplicated 3 times. I am assuming I am getting this due to the Join, my records from View A, the same records from View B, and the same records from the Join. What can I do to only get 1 set of records and avoid duplicates?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.