I need to do a join on two fields but only part of the data in the fields.
the field is 18 digits long but I need the join to be dependent on only the first ten digits.
example.
2 account id's below
000000000055555555
000000000066666666
I need them to match by the first ten digits so the two above referenced accounts would result in a match