I was wondering why I encounter such errors.

You might think that I could use the TableCalls alone but I just used a query table so you could see the bug(?) i don't know if it's me or the zoho reporting that causes the error but take a look at the first pic:

I wrote a simple select function in Query Table and as you can see... the ROW COUNT IS 800,000

But the real total row count is:

How can you explain this? Am I doing something wrong?

Please assist me on this... I am joining 2 tables but I get 800,000 records max and it doesn't give efficient results.

Thanks,

CJ