Question

    Join in which result is generated only when variable matches from both tables.

    A inner join Correct Answer Incorrect Answer
    B left outer join Correct Answer Incorrect Answer
    C right outer join Correct Answer Incorrect Answer
    D outer join Correct Answer Incorrect Answer
    E full join Correct Answer Incorrect Answer

    Solution

    The inner join is a form of join in MySQL that is used to combine the result of concatenating the contents of two tables into a new table. In inner join, result is produced by matching rows in one table with rows in another table.

    Practice Next
    ×
    ×