As a Mets fan, I have literally been waiting for that all my life (other than the first two years, when there were no Mets.)
I remember as a nine-year old watching Tom Seaver's "Imperfect Game" against the Cubs, and Jimmy Qualis getting a bloop hit with one out in the ninth, and his two other late no-hitters.
I believe that leaves San Diego as the only team without a no-hitter. (Yep, and Wikipedia has already been updated.) Preston Gomez sent in a pinch hitter at least once, and I believe it may have been twice, while the pitcher (Randy Jones?) was throwing a no-hitter, and the relief pitcher gave up a hit.