Re: Joining fields in queries using partial values

pietlinden@xxxxxxxxxxx wrote:
Of course you can do non-equi joins. You just can't do them in the
QBE.

But it's non-optimal, as the join can't use indexes. The examples
are clearly cases where the parts of the single value should be
stored in multiple fields.

David,
could you post an example? Joining on something like
INNER JOIN ON LEFT(tableA.MyField,4) = LEFT(tableB.OtherField,4) ?

SELECT tableA.MyField, B.OtherField
FROM tableA INNER JOIN tableB
ON LEFT(tableA.MyField,4) = LEFT(tableB.OtherField,4)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages
Loading