What is join? Mention its types.

devquora
devquora

Posted On: Feb 22, 2018

 

Join depicts the relationship between two or more tables. It combines row of different tables and enables you to select data with reference to data of some other table. There are several joins in database like CROSS JOINs, NATURAL JOINs, EQUI-JOIN, etc. Two most important joins are –

  • INNER JOIN – this join returns values that have matching record in both the tables. In this, blank rows are combined in middle.
  • OUTER JOIN– it returns all the records of left table. It also returns the values that match with the right table. Blank rows are put in specified side by joining tables in other side.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    DBMS Interview Questions

    What is DBMS?

    DBMS (Database Management System) is a computer software application that allows users and other applications to view,..

    DBMS Interview Questions

    Enlist various types of interactions created by DBMS ?

    There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..

    DBMS Interview Questions

    What are the features of Database language?

    Database language is used to create and store data in computer system. DBMS itself is one of the features of database l..