CVS Health Interview Question

Describe the difference in join types in a SQL environment.