Link to home
Start Free TrialLog in
Avatar of Jim Metcalf
Jim MetcalfFlag for United States of America

asked on

help with query

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
ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Review your model. Looks like a violation of 1NF.
Avatar of Jim Metcalf

ASKER

Worked like a charm Scott.