PrepAway - Latest Free Exam Questions & Answers

Which join type should you use?

Your network contains a System Center 2012 Configuration Manager environment.
You have the following query:
Select Name
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?

PrepAway - Latest Free Exam Questions & Answers

A.
LEFT

B.
FULL

C.
INNER

D.
RIGHT

3 Comments on “Which join type should you use?


Leave a Reply