General information
Forum:
Microsoft SQL Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only