It depends on what indexes you have. If you have indexes on each int field than

select * from mytable1 join mytable2 ;
  on mytable1.intfld1 = mytable2.intfld1 and mytable1.intfld2 = mytable2.intfld2

It's also standard SQL that will run on most other backends w/o modifications.

>
>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?