PCL Construction Interview Question

What is the difference among JOIN statements?