Hi All

I cannot explain my self-regarding the following query.

I have 3 tables and table c has one column FieldStatus and its value = 100.

But in where clause of the query I put FieldStatus = 0 even then it is showing in the result.

values in table tbl_FieldReviewStatus c

originid appid fieldstatus
-------- ----------- -----------
01 100008 100

select c.originid,c.appid,a.originid,a.appid, c.FieldStatus from tbl_application a, tbl_yellowsheet b,tbl_FieldReviewStatus c
where a.originid=b.originid and a.appid=b.appid and a.originid*=c.originid and a.appid*=c.appid and b.SSStampedDate is not null
and a.requiredfr=1 and a.ProjectCanceled is null and c.FieldStatus=0
order by a.originid ,a.appid

result I got from above query is

originid appid originid appid FieldStatus
-------- ----------- -------- ----------- -----------
NULL NULL 01 100008 NULL


how come this record is showing in this query.

thanks
...ashish