2. PHPRunner General questions
  3. set a filter on subquery
This topic is locked

set a filter on subquery

 		1/16/2012 10:55:42 AM
PHPRunner General questions
P
 phneoix author

hi,

how do set filter on a subquery like this.
select id from job_operations where _jobid=2 and id not in

(SELECT operation_id from operation_status where _proj_id=1_and _jobid=2)
C
 		cgphp 1/16/2012

Your query is correct, what's the problem?
P
 		phneoix author 1/16/2012



Your query is correct, what's the problem?


select

id,

job_id,

operation_desc

FROM job_operations

WHERE (id not in

(SELECT operation_id from operationstatus {where clause}_))
i want to add a filter to the subquery. is it possible.??