Problem linking 2 tables

[medeya]

I am trying to link 2 table by the fields that have different representations. Table a : Tck_Code = 1TQ
Table b : Tck_Code = 1TQ7005FR. Then I go to the select formila and edit it so that the code in the second table equates the field from the first table . I do it like this LEFT( SecondTable.Field, 3 ).
It gives me
ODBC errorMicrosoft)(ODBC SQL Server Driver)COUNT field incorrect.
Error detected by database dll.
What I am doing wrong ?

 

[EarlGray]

Try changing the = to a LIKE:
Tablea.Field : Tck_Code = 1TQ
Tableb.Field : Tck_Code = 1TQ7005FR
Select Formula:
Tablea.Field LIKE Tableb.Field + *

The LIKE should pick out any 1TQs you might have in Table B

ECS DataSystems, Inc.

http://www.ecsdata.com

A Crystal Partner

 

[medeya]

Thank you for your response.
But in my tables I have different codes, not just 1TQ. I need to get all the codes from the second table matching the codes in the first.