>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.
If it's not broken, fix it until it is.
My Blog