Comcast Interview Question

Difference between join and inner join