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.
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.