Join two tables

[Anna]

Hi:

Can any one please help me how to i join both tables so that i get
value from FieldC. Table A of val(left(FieldA,5))=Table B

of FieldA

Table A
FieldA, FieldB
02212-324354-02, 123
03243-657483-98, 324
05463-928764-07, 443

Table B
FieldA, FieldB, FieldC
2212,123,ABCDEF
3243,324,GHIJLK
5463,443,LMNOPO

Thanks.

 

[Douglas J. Steele]

Create the query as though FieldA in Table A could be joined directly to
FieldA in Table B, then switch to the SQL view of the query (under the View
menu) and manually change the SQL from

ON [Table A].FieldA = [Table B].FieldB

to

ON Val(Left([Table A].FieldA,5)) = [Table B].FieldB

 

[J. Goddard]

Hi -

Join the tables in a query, using FieldB of each to join them, and
include TableB.fieldC in the query. Tables can be joined on any field,
not just the first one.

John