Talk about the difference between INNER JOIN and LFET JOIN.

Talk about the difference between INNER JOIN and LFET JOIN.

请帮忙给出正确答案和分析，谢谢！