>>
>>Interestingly, if you create a tag on LEFT(ID,4) in the TABB table, it works.
>>
>
>It also works if you change WHERE NOT EMPTY(taba.field2) to WHERE taba.field2<>" ".
>
>Seems like the bug is with EMPTY()
Hi Brad,
Not exactly. The field2 itself is incorrect in result also, Null instead of blank.
--sb--