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...
Top Bottom