* 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