>>Good evening,
>>
>>I need to join two tables on 2 integer fields but not sure what is the best way to do it. Here is one way I see that it can be done:
>>
>>
>>select * from mytable1 join mytable2 on bintoc(mytable1.intfld1) + bintoc (mytable1.intfld2) =
>>bintoc(mytable2.intfld1) + bintoc(mytable2.intfld2)
>>
>>
>>Is concatenating these two fields with BINTOC() the best way?
>>
>>Thank you.
>
>Why not just use INNER JOIN myTabl2 on MyTable.IntField1 = myTable2.IntField1 and myTable.IntField2 = myTable.IntField2?
>
>In other words, simple AND condition would be much better if you have indexes on each of integer fields.
Think about laaaarge tables and existing tag on bintoc() - much less work for rushmore, especially if one of the Ints is not highly selective. just visualize it <g>...
regards
thomas