Tech Off Post

Single Post Permalink

View Thread: SQL and JOIN
  • User profile image
    grassBlade

    Perhaps I'm out of my league here (not having played with sql in many moons); however, I would presume performance would be faster for the 2nd command ('AND') since the subset of  ms.Labels = 22 is presumably smaller and (if indexed) would mean fewer checking of IDs.