Database Developer Question:
Download Questions PDF

Tell us what is the difference between an inner and outer join?

Answer:

An inner join returns rows when there is at least some matching data between two (or more) tables that are being compared.
An outer join returns rows from both tables that include the records that are unmatched from one or both the tables.

Download Database Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell us what is a Trigger?Tell us what is SQL?