[stackoverflow] [progress Openedge Abl] Writing A Nested 4gl Query After 'where'

[Baked Inhalf]

I only have access to write a 4gl query after Where(. Is it possible to write a nested query to search in a completely different table?

For example

**FOR EACH WORK_ORDER WHERE(**

//my query starts on this line
1=1 and
( for each purchase_order where key <> '123' end)


This obviously does not work, but is it possible to make it work? This query will give me ERROR: PREPARE syntax is {FOR|PRESELECT} EACH OF..WHERE" (7324)

Continue reading...