help removing reps

[canberry]

I am creating a query template but im faced with getting duplicates for some records. Eg. I have T1 and T2 Left joined by common feild id
T1 T2
Name id Name id type
Ford 022 Ford 022 Suv
Benz 025 Ford ltd 022 Suv
Benz 025 sedan

So when i join these two tables. My output is:
Ford 022 Suv
Ford ltd 022 Suv
Benz 025 sedan


Really should be: Ford 022 Suv
Benz 025 sedan

Can this be resolved cas im also working with numerical feilds.

 

[RuralGuy]

Do you have any control over changing the fields?

 

[canberry]

Nope. Not really. What are u suggesting?

 

[namliam]

T1           T2
Name id    Name id type
Ford 022   Ford 022 Suv
Benz 025   Ford ltd 022 Suv
               Benz 025 sedan
 
So when i join these two tables. My output is:
Ford 022 Suv
Ford ltd 022 Suv
Benz 025 sedan
 
 
Really should be: Ford 022 Suv
                      Benz 025 sedan

No there is no way to do that without altering the data. if you are joining on the ID (022) you will find 2 fords... Offcourse you can do different sort of trickery but really the data is basicaly flawed and that is what should be fixed.

Good luck