IT Questions and Answers :)

Tuesday, July 10, 2018

In Crystal Reports, what type of Join statement lists values from all records of the right table and only records of the left table where the join fields match?

In Crystal Reports, what type of Join statement lists values from all records of the right table and only records of the left table where the join fields match?

  • Left Outer Join
  • Right Outer Join
  • Inner Join
  • Cross inner join 

In Crystal Reports, what type of Join statement lists values from all records of the right table and only records of the left table where the join fields match?

EXPLANATION

Right Outer Join lists all records from the right table and those in the left that match only.
Left Outer join lists all values from the left table and only those in the right table where the join fields match
Inner Join only shows values in the tables where the join fields match.
Cross Inner join is not a valid join type

SOURCE

http://us.flukecal.com/literature/technical-bulletins/metcal/application-note/setting-join-types-crystal-reports
Share:

Popular Posts