I have 2 tables, one with dst codes and one with fees. I want to match the fees with the dst code. I've been trying a for loop but it's not working 100%.
What is the best way of matching dst code with the corresponding fee? If TABLE A (dst_code 011) matches TABLE B's (fee 011) then the cost will be 0.38 etc...
[U]TABLE A[/U] dst_code 011 dst code 012 dst_code 013 [U]TABLE B[/U] fee 011 0.38 fee 012 0.55 fee 013 0.55