Linking two SQL tables

[ncopeland]

I am having a small problem. I want to link two tables. Unfortunately the two SQL tables do not have the same key.

In one of the tables there is a code field which is made up of a two character warehouse field and the product code.

In the other table these fields are seperate. I want to be able to join the fields together in this table and link them to the code in the other table.

I was wondering if anybody had done this. I have had a look at subreports for linking this but have struggled. Any help greatly appreciated.

Kind Regards

Neil Copeland.

 

[marckssg]

The only time I've done this in the past I've created a "View" in Toad of the table with the information in two seperate fields, then having created the view by hard coding the SQL I've then joined the view to the 1st table in crystal reports. Cheers

Marc

http://www.signifyservices.com

 

[IanWaterman]

Hi

Suggest you use a subreport. Main report looks at the tables where there is a code field which is made up of a two character warehouse field and the product code.

Subreport looks at the other table.

Create a formula which trims out the warehouse code from your field. Then link the main report to the subreport using the formula and the field for the separate Warehouse code.

If you want to add totals together you will need to then create global variables and add them in the main report.

Hope this helps

Ian Waterman
UK Based Crystal Consultant