B
Baked Inhalf
Guest
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...
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...