EXPLAIN "ENFORCED TO", "ENFORCED FROM", "ENFORCED BOTH" JOIN CONDITIONS
Posted on 2005-04-19
I am joining 2 tables via a Left outer join. I want all the records in the primary table to be included and only those records inthe secondary where my joined field is equal, to be included. THe link is created, but I am getting way too many records.
When I view the link options, I see Crystal placed the default of "NOT ENFORCED". I do not know what this means exactly. The options are "NOT ENFORCED". "ENFORCED TO", "ENFORCED FROM", "ENFORCED BOTH" .
Which of these options should I click to get the results I list in the first paragraph
EXAMPLE if My primary table was the Customers table and the secondary table was the orders tbl:
Customer Table Customer Table Orders Table
Customer ID Customer Name Order Amount
52 Allez Distribution 25141.50
53 BG Mountain Inc. 19164.30
53 BG Mountain Inc. 1683.60
57 Hansen MTB Inc. 15716.40
54 Bicicletas Aztecas
55 Deely MTB Inc.