Left join vs left semi join vs outer join. El agüitado lyrics translation.

I want to know if you ever seen the rain original lyrics. 橋本一径ひろゆき.