QoQ Help!

emmim44 · January 12, 2010, 6:56pm

Query Of Queries syntax error.
Encountered "event_number in ( select. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

Output SQL

select * from SearchRes0 where event_number in ( select distinct p.event_number from ops$new.ne_node n , ops$new.ne_problem p , ops$new.ne_lob l where 1 = 1 and p.event_number = n.event_number and p.event_number = l.event_number And p.problem_code in (30,40) )

r937 · January 12, 2010, 8:09pm

weird

could we see the actual CFQUERY statements?

system · January 12, 2010, 9:55pm

Do QoQ’s actually support that type of subquery? I’d be very surprised if they did, as QoQ’s are quite limited.

emmim44 · January 13, 2010, 3:02pm

Something else is not right…any ideas?

system · January 13, 2010, 3:30pm

Something else is not right…any ideas?

Yes… what I already said

"Do QoQ's actually support that _type_ of subquery?"

I would bet money the answer is NO

r937 · January 13, 2010, 5:54pm

could we see the actual CFQUERY statements?

emmim44 · January 14, 2010, 7:22pm

I have used in (#valuelist(Querycolumn name#) , and it work… Thank you all