Infosys Interview Question

What is a JOIN in dbms and write the query