Skip to Content
0
Former Member
Dec 08, 2008 at 05:43 AM

Combining two tables into one result

39 Views

Hi all, I am fairly inexperienced with Crystal but have gained good results from the reports I have created, I am fluent in SQL and Basic to an extent. I am interigating a Pronto database and I want concatenate two tables into one report.

Table One: Customer Orders

Fields: Customer No, Invoice Number, Invoice date, Invoice Amount, Cost Amount.

Table Two: Archived Customer Orders

Fields: Customer No, Invoice Number, Invoice date, Invoice Amount, Cost Amount.

I want to complete a report that will tell me the sales for a given period and the outstanding orders for each customer total for all fields in each table combined into one figure.

Any help would be greatly appreciated.

Thanks in advance