Database View Syntax for where clause

[dlrich]

I want to filter a database view so that the output is only certain values in the view.   For example, on the task table, I want task to be of certain task type or certain states (tsk_sys_class_name = 'sc_request' AND tsk_state = '1')
but nothing I do seems to work.

[smcdonaldaz]

For me increasing the order did not change anything.  I was missing "Left join".  Strange error for not making it a left join.