molemenacer wrote:
I have a query that searches on a number of criteria and would like help on
the last line
I have included my code below:
where
jobs.statusid in (6) and
ifnull(jobs.currworkerid,'') like '%' and
jobs.dictatorid like '%' and
jobs.custcode like '%' and
jobs.deptcode like '%' and
jobs.specialitycode like '%' and
ifnull(jobs.prevworkerid,'') like '%' and
jobs.jobid like '%' and
jobs.supplierid like '%' and
Approveddate between '2006-09-14' and '2006-09-21' or Approveddate Is Null
This retrurns all jobs whether they are status 6 or not, i need to have a
comparison on approveddate, it is either between the two dates or null, but
is status 6.
( Approveddate between '2006-09-14' and '2006-09-21' or Approveddate Is
Null )
Your query returned all rows where approveddate is NULL.
--
Gerald L. Clark
Supplier Systems Corporation
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]