SQL Server Database Administrator Question: Download Questions PDF
What is a join and explain different types of joins?
Answer:
Joins are used in queries to explain how different tables are related. Joins also let you select data from a table depending upon data from another table.
Types of joins:
INNER JOINs,
OUTER JOINs,
CROSS JOINs.
OUTER JOINs are further classified as
LEFT OUTER JOINS,
RIGHT OUTER JOINS and
FULL OUTER JOINS.
Types of joins:
INNER JOINs,
OUTER JOINs,
CROSS JOINs.
OUTER JOINs are further classified as
LEFT OUTER JOINS,
RIGHT OUTER JOINS and
FULL OUTER JOINS.
Download SQL Server DB Administrator Interview Questions And Answers
PDF