No. For some reason, even though I can the ids are identical, it is not seeing a match in table2. :o(
>Does it work correctly with the INNER JOIN for matching records only?
>
>>No.
>>
>>>>Wouldn't LEFT JOIN ON alltrim(upper(table1.aid))==alltrim(upper(table2.bid)) work regardless?
>>>>
>>>Yes, it would. Never used such construction in JOIN myself, but it would work regardless, you're right. Do you have NULL in any of ID fields?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"