Only joins rows for which name does not contain the NULL value!!!
FROM a, b means the cartesian product of a and b (m rows in a, n rows in b means m*n rows for the cartesian product!)
Explain use of aliases for tables?