On Thu, Oct 9, 2014 at 2:44 PM, Dan Goldberg <[email protected]> wrote:
> Hmm, I will have to see if this runs faster. > > Thx > Dan, It will not be any faster than the example I gave you. It might be the same. The one I gave you could trigger an error code if there happen to be two or more rows with the same partnumber on the same max (effdate). To prevent that, you could add "AND LIMIT = 1" at the end of the WHERE clause (after the close parenthesis.
