Thread: Linking two data sources

I have two different datasources that have tables I want to link together and in one of the sources a certain key is stored in the following format:

000000123456 it will be a 12 digit string no matter how big the key is with 0's in front for place holders

in the other data source the key is just 123456

Is there anyway to link these two sources together using Crystal 10 without using sql (you can't use it when you are pulling from multiple data sources in crystal)

Wow I am not paying attention heres an update to my post

Linking a group of tables from 2 different databases. They both have the same key (theoretically) except they store the keys differently.

Welcome to DeveloperBarn

What do you mean by "linking" and what are you trying to "link" them by?