Pergunta de entrevista da empresa Infosys

What is a JOIN in dbms and write the query