[AccessD] Joining Two Tables

Gustav Brock gustav at cactus.dk
Thu Nov 11 05:07:07 CST 2004


Hi Mark and Arthur

That may work but you'll be in trouble when trying to switch to design
view.
I would create a query for Tbl2 with a field with the expression
needed to match the Tbl1.Fld1. Then use this query for Tbl1 whenever
you need to join Tbl1 and Tbl2.

/gustav


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




More information about the AccessD mailing list