Temporary files in SQL command possible?

[Frodnew]

Is it possible to build a two step SQL command? I would like to link file A to file B and then link this resulting file with a file C.

The tricky part (at least for me) is that there can be multiple records on file A for each record on file B. And there can be multiple records on file C for each record on file B. And all three files contain numeric information that must be aggregated. A normal join results in the data being doubled, tripled, etc.

Clear as mud?

Bruce

 

[fredp1]

It sounds like all you shoud need is a complex sql statement(depening on the answers below)
.
You'll need to provide details of version for Crystal and the db you are using. Also the tables with the columns and data and the Results that you want to see.


Cheers
Fred