Joining distinct values

[Anonymous]

I have a table with ID 01, 001, and 0001

I have another Table using one of those IDs.  when I join the tables I see all three joined.  Is there a way around this?

[tiago_juncioni]

Use Text(ID) for join, in both table.

regards

[Anonymous]

unfortunately, this did not work.  Is there another way?

[Thiago_Justen_]

What about this:

Replace ('ID','0','X') as NewID

In both table.

[dwforest]

Did you try Text(ID) in the load script from the original source?

What is the source?

[Anonymous]

the data is coming from a qvd File.

[vishsaggi]

Use Autonumber(ID) AS KeyID