How do you adjust the query to return the missing records in the preview?

You create a query using the Basic User Information table. After you add the Proxy Information table, you notice that some of the basic information records are NO longer displayed in the preview.

How do you adjust the query to return the missing records in the preview?
A . Remove the related table and add it using the Show Related Tables command form the Action Menu.
B . Change the join type to Left Outer Join.
C . Remove the related table and select and drag it from the Available Data section.
D . Change the join type to Inner Join.

Answer: B

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments