All three tables have the same integer key, and it's indexed.
I parenthesized the joins to do the two small tables first.
I'm running and INSERT INTO ... SELECT query with this join (one record added per record in join), 4 hours down and all I have to show for it is 100 recycled transaction logs. ?
If it ever returns, I can post the Explain output.