[SOLVED] Query ?

[ainoy31]

Trying to query a table and one of the column can be values of either NULL, 0, or 1.

 

Here is my query

select complaint_flag, sessionid from table.orders where insert_date >= '2009-05-26' and order_status='done' and complaint_flag != '1' and complaint_flag is null

 

That should return about 1636 rows but it returns zero.  I am missing something here?

 

Much appreciation.  AM

[kickstart]

Hi

 

select complaint_flag, sessionid from table.orders

where insert_date >= '2009-05-26'

and order_status='done'

and complaint_flag != '1'

and complaint_flag is null

 

Why the 2 clauses? If the 2nd is true then the first is irrelevant.

 

All the best

 

Keith

[ainoy31]

Here is my solution:

 

select complaint_flag, sessionid from govirs.orders where insert_date >= '2009-05-26' and order_status='done' and (complaint_flag != '1' or complaint_flag is null)

 

I needed a () around my OR statement.  I needed to account for the complaint_flag value to be null or zero.

 

Later. AM

[kickstart]

Hi

 

Unless NULL has a different meaning on this column than 0 then I would be tempted to just give that column a default value of 0.

 

All the best

 

Keith