What is type of record FieldStatus
>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