* I have the following tables:
create cursor apps_ (appid i, appname c(10))
insert into apps_ values (1,"AppV1") && version 1 of app1
insert into apps_ values (2,"OtherApp")
insert into apps_ values (3,"Yetanother")
insert into apps_ values (4,"AppV2") && version 2 of app1
create cursor modules_ (moduleid i, appid i, modulename c(10))
insert into modules_ values (1,1,"Demand Module") && app version 1, demand module
insert into modules_ values (2,4,"Demand Module") && app version 2, demand module
insert into modules_ values (3,1,"Inv Module")    && app version 1, inv module
insert into modules_ values (4,4,"Inv Module")    && app version 2, inv module

* Given: ModuleName = 'Inv Module' OR ModuleID = 3
* Can I create a single query to give me the following result:
*   appid, appname
*       1  "AppV1"
*       4  "AppV2