Explain with help of examples how and when the  SQL joins statements are used,  the examples should clearly state the differences.