>>>Sam, you're using table2 on top of table1
>>>try this: before using table2...SELECT 0
>>
>>Thanks Matt,
>>
>>But I still don't understand the concept of this. When I use scan for seek('blah') I had select the alias on which the table I'm comparing right. How come, it doesn't seen to compare the index of two tables???
>
>Sam, that was that point. You weren't comparing two tables. When you used table2, you closed table1. If it's still not working, please post the new code.

The code works fine, thanks Matt. I just want to understand why it didn't comparing the two tables.