Recent content by PSJupiter2

  1. P

    Unruly query: multiple iterations of same table, poor performance

    Sorry, as I said, I am new to this forum. My original post included attachments, which showed an example of my data. I am not sure where they went! I did add them again. I do not want several iterations of my table. But I don't know how else to join my tables without doing this. I am open...
  2. P

    Unruly query: multiple iterations of same table, poor performance

    Thank you, this solved my immediate problem. I ended up doing just that and adding primary keys to my local tables. I was concerned about the performance implications of "mixing" network and local tables. But it doesn't seem to matter in this case. On pitfall here, however, is that if the...
  3. P

    Unruly query: multiple iterations of same table, poor performance

    Hello, I am new here, so I will do my best with etiquette. TLDR: I have a query with 14 iterations of a table to pull descriptive data. Performance begins to suffer exponentially after the 10th iteration, why does this happen? Also, does anyone have suggestions to tame this unruly beast...
Back
Top Bottom