Your network contains a System Center 2012 Configuration Manager environment.
You have the following query:
Select
R .Name,
U .UserName
From
SMS_R_System R
Join SMS_R_User U
On R.LastLogonUserName = U.UserName
You need to ensure that all of the client computers are listed in the query results.
Which join type should you use?
A.
LEFT
B.
FULL
C.
INNER
D.
RIGHT
Explanation:
http://www.w3schools.com/sql/sql_join_left.asp
SQL LEFT JOIN Keyword
The LEFT JOIN keyword returns all rows from the left table (table_name1), even if there are no
matches in the right table (table_name2).
Further information:
http://www.w3schools.com/sql/sql_join_full.asp
SQL FULL JOIN Keyword
The FULL JOIN keyword return rows when there is a match in one of the tables.
http://www.w3schools.com/sql/sql_join_inner.asp
SQL INNER JOIN Keyword
The INNER JOIN keyword returns rows when there is at least one match in both tables.
http://www.w3schools.com/sql/sql_join_right.asp
SQL RIGHT JOIN Keyword
The RIGHT JOIN keyword returns all the rows from the right table (table_name2), even if there are
no matches in the left table (table_name1).