A Query Line can be one of three types: DataItem, Column, and Filter. Each has its own property set. Query DataItem properties can be accessed by highlighting a DataItem line and clicking on the Properties icon, clicking on Shift + F4, or by navigating to View | Properties:

Again, we'll review a selected subset of these properties:

• Indentation: This indicates the relative position of this line within the Query's data hierarchy. The position in the hierarchy, combined with the purpose of the line, such as data, lookup, or total, determines the sequence of processing within the Query.
• DataItemLinkType: This can only be used for the subordinate DataItem relative to its parent DataItem, in other words, it only applies in a Query that has multiple DataItems. There are three value options:
  • Use Default Values if No Match: This includes the parent DataItem row, even when there is no matching row in the subordinate DataItem
  • Exclude Row if No Match: This skips the parent DataItem row if there is no matching row in the subordinate DataItem
  • SQL Advanced Options: This enables another property: the SQLJoinType property
• SQLJoinType: If enabled by the DataItemLinkType property, this property allows the specification of one of five different SQL Join Types (Inner, Left Outer, Right Outer, Full Outer, or Cross Join). More information is available in the Help sections, SQLJoinType Property and SQL Advanced Options for Data Item Link Types.
• DataItemTableFilter: This provides the ability to define filters to be applied to the DataItem.