Pergunta de entrevista da empresa Rexall

What are the type of JOINS in SQL and please explain.