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.
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 Question | Next Question |
| Tell us what is a Trigger? | Tell us what is SQL? |