Hi, I have problem with one query...
I have 2 tables. One table nemed "Customers" witch contain field named "Serial" with 8 characters. In other table named "Counters" I have field named "SerialNumber" wich is 11 characters long.
What I want to do is connect this two tables with criteria where field "Serial" from table "Customers" look for LIKE in field "SerialNumber" from table "Counters".
Example... if field "Serial" in table "Customers" have record 12345678, must be matched with record in table "Counters", field "SerialNumber" wich have value 95812345678.
How to do that?