Joining 2 fields between 2 tables

I need to join 2 tables together using 2 fields. For Example, I need to join 2 tables to beginning milepoint field and ending milepoint field. I thought I could use Add Join in thedata management box but I can't seem to get that to work. Any suggestions?????

Yeah, that's the add join. I was reading it some more I don't think that will work. Because, I need 2 fields to 2 fields. Let me explain some more. So, in one table I have a field bmp and a field emp. Like such 0.123 and 1.234. Then I have another table with a field bmp and a field emp. Like such 0.123 and 1.234. I need to join the 2 fields on both tables. So, in the end I'll end up with one table with 4 fields that are the same.

If I am understanding you correctly, you probably have duplicate "bmp" entries and you only want them to join "IF" the "bmp" AND the "EMP" are the same as the other table row. Someone that knows python might be able to get you going in the right direction. I just don't know python well enough to say it can be done.

My workaround would be to add another field in and field calculate the value to be a combination of the bmp and emp.

ie: BMPandEMP

Do the same for the other table. I know it adds extra fields, but they would then be unique for joining purposes.