OPNQRYF Question

[Gary Munroe <GMUNROE@xxxxxxxxxxxxxx>]

I've got a little logic problem when working with OPNQRYF that I 
know I can do in straight SQL (which is not available for my 
process).  I'm thinking OPNQRYF might not be able to handle it.  
Essentially I want to do the following via the OPNQRYF command:

SELECT * FROM COURSES
  WHERE SOMECODE = "" AND
  LOCATION IN 
    (SELECT ID FROM TABLELOOKUP
     WHERE LEVEL = "02" AND (TABLEID = &TNAME1
           OR TABLEID = &TNAME2)
    )

Basically the user could enter up to two region names (&TNAME1 
and &TNAME2) which use a lookup table containing the real location 
codes that have to be compared with the codes on file.

Can someone tell me whether this is possible or not?

Thanks.


 ___________________________________________________________________
| Gary Munroe                                                      |
|------------------------------------------------------------------|
| I.T.S., Information Services Group  Work: gmunroe@flemingc.on.ca |
| Sir Sandford Fleming College        Home: izzi@calweb.com        |
| (705) 749-5523 x1409                                             |
|__________________________________________________________________|
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---