Describe the types of outer joins.

What will be an ideal response?


There are actually three types of outer joins. In a left outer join, all rows from the table on the left (the table listed first in the query) will be included regardless of whether they match rows from the table on the right (the table listed second in the query). Rows from the table on the right will be included only if they match. In a right outer join, all rows from the table on the right will be included regardless of whether they match rows from the table on the left. Rows from the table on the left will be included only if they match. In a full outer join, all rows from both tables will be included regardless of whether they match rows from the other table.

Computer Science & Information Technology

You might also like to view...

The ____is located within the bottom margin of the document.

A. capper B. header C. base D. footer

Computer Science & Information Technology

List and describe two role services that you can implement when you install Active Directory Certificate Services.

What will be an ideal response?

Computer Science & Information Technology

The task-based command-line scripting interface that enables you to perform a large number of remote management tasks is _____________________

a. Remote Assistance b. Windows Remote Management c. Remote Desktop d. Windows PowerShell

Computer Science & Information Technology

A(n) hides the internal network's IP address and presents a single IP address to the outside world

a. Firewall b. Proxy server c. Intrusion detection system d. Network Monitor

Computer Science & Information Technology