CVS Health interview question

Describe the difference in join types in a SQL environment.