Linking tables together by a formula?

[retygh45]

Using CR11, I have 2 tables that I'm trying to link, which contain file name information. Basically, we have files here that we upload to a remote data center.

We log our files to SQL in 2 columns: file name, and file extension. and the remote office uses just file name, which contains the extension.

So table 1 looks like this:

FILE EXT
img001 tif
img002 tif
img003 tif

and the 2nd table looks like this:

FILE
img001.tif
img002.tif
img003.tif

Is there any way that I can link these two SQL tables together in the database expert window or some other way? I know I can make a formula combining the 2 name and ext. in the first table but I don't know how to link them.

Any help is greatly appreciated, thanks!

 

[hilfy]

I think that your best bet is going to be to see if you can use a CommandText instead of using the tables directly. With a Command, you can write your own SQL so you can join your tables however you want to. However, Crystal doesn't support commands for all database flavors. To determine if you can use it, connect to your database from your report and look for the option "Add Command" right below the database name.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.