title: What is the benefit of Enforce Join option in Crystal Reports?
body: <p>What is the benefit the makes SAP Crystal reports Enforce Join default option in Link Dialog is "Not Enforced"?</p>
  
  <p>Is it performance issue? because I noticed if you don't select field from the joined table it'll generate SELECT query with only fields of the selected Table only without any joins.</p>
  
  <p>here's some information about the Enforce Join options:</p>
  
  <ul>
  <li><p><strong>Not Enforced</strong>: When you select this option, the link
  you've created is used only if it's
  explicitly required by the Select
  statement. This is the default
  option. Your users can create reports
  based on the selected tables without
  restriction (that is, without
  enforcement based on other tables).</p></li>
  <li><p><strong>Enforced From</strong>: When you select this
  option, if the "to" table for the
  link is used, the link is enforced.
  For example, if you create a link
  from Table A to Table B using Enforce
  From and select only a field from
  Table B, the Select statement will
  still include the join to Table A
  because it is enforced. Conversely,
  selecting only from Table A with the
  same join condition will not cause
  the join to Table B to be enforced.</p></li>
  <li><p><strong>Enforced To</strong>: When you select this
  option, if the "from" table for the
  link is used, the link is enforced.
  For example, if you create a link
  from Table A to Table B using Enforce
  To and select only a field from Table
  A, the join to Table B will be
  enforced, and the Select statement
  that is generated will include both
  tables.</p></li>
  <li><p><strong>Enforced Both</strong>: When you select this
  option, if either the "from" table or
  the "to" table for this link is used,
  the link is enforced.</p></li>
  </ul>