you can't use a varchar for the join in the "ON" clause or it bombs. Create a numeric join field or join on a numeric and you'll be ok.