IT Questions and Answers :)

animated-update-image-0026

COVID-19 India HEAT MAP

A message to our readers about COVID-19

With the uncertainty surrounding the outbreak of the corona virus. We want to reassure our reader stay safe and Healthy.Be aware and alert. Work as one nation. Sanitize and disinfect all equipment before entering your home, work and anywhere.

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:

0 comments:

Post a Comment

Popular Posts