I have two tables with the same fields: current invoices and past invoices. I want to join the two so that I will be able to create a list of all current and past orders per customer and write formulas to total up various info like count each customer's orders and sum freight costs.
I have tried creating a right outer join based on the customer number field, and the link is enforced on both tables. This results in many duplicate records from each table. Select Distinct Records is checked.
I would love any suggestions about how to remedy this as well as how to write formulas based on the union of the two tables. I'm pretty new to Crystal but have not run into issues until trying to combine tables with the same fields, so I assume there is a way to set it up appropriately that I'm unaware of. Thanks much.
EDIT: I found where to put an SQL statement to join the tables in a union instead, so I think I have solved this.
Edited by zann, 29 September 2010 - 12:02 PM.