[AccessD] Joining Two Tables

Mitsules, Mark wrote:

>Group,
>
>I have two tables I would like to join.  Tbl1.Fld1 contains a
>variable-length string, Tbl2.Fld2 contains the same variable-length string
>concatenated with a variable-length suffix.
>
>Any suggestions on how to proceed?  Is there an elegant solution?
>
>
>Mark
>  
>
At first blush I would try this:

SELECT * FROM T1 INNER JOIN T2 ON T1.Field1 = Left(T.2.Field1, 
LEN(T1.Field1))

Arthur