You need to tell it which of the MPI values to use in your SELECT list. Nevermind that you tell it they have to be the same in your WHERE clause, it still wants to know which one you meant in the SELECT list (sometimes database engines can be a wee bit dense).

-PatP