We have upgraded DB from Sybase 6.0 to SQL Anywhere 11.
After upgradation we are facing a few issues.
One of them is as follows :

Please have a look at the attached DB.

While running the below query, the count returned is 0.
If we remove the //
in the below query,
the count is properly returned as 4.


Could you please let us the resolution for the same. We are badly stuck up.


Query:

SELECT count(*)

from dba.tblcompmst ,

dba.employeemastercompany //WITH (NO INDEX)

WHERE

dba.tblcompmst.ncocodegrp = dba.employeemastercompany.ncocodegrp and

dba.tblcompmst.ncocode = dba.employeemastercompany.ncocode and

dba.employeemastercompany.ncocodegrp = 2 AND

dba.employeemastercompany.employeeno =110 AND

dba.tblcompmst.ncostatus = 1