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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham