I re-posted the picture of the "schema" in my first post. I found and corrected a "MyBad"!

I am getting some blanks for teamid in Table3 after the merge, and when...

Thanks, the query works great, except 'yearid' isn't retrieved and I also need that in Table3 to show what year they played LF for 112 games, etc.

• This reply was modified 3 years, 8 months ago by William Zabob.