schambers/fluentmigrator — Issue #211: USING OR
Author: nkaiseng
Created: 2011-12-19 17:40:10+00:00
State: open

Hi All, please help me with this....

Select * from Jobs
where (jobs.To_complete_by < '12/19/2011 6:46:15 PM'
and jobs.jobstatus like 'o') or (jobs.completed_on <= '2011-12-31 23:59:59'
and jobs.completed_on >= '2011-12-01 00:00:00'
and jobs.completed_on > jobs.To_complete_by )