He joined the band in 1987 and played and sang on every one of their recordings ever since. He was just 62 and had been battling cancer