in reply to How to use * operator in JOIN

What Laurent_R and johngg said. For documentation of the repetition operator, see Multiplicative Operators.

#11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.