Version Data Sdelection and Event Rule Set User Selection Relationship

Version Data Selection and Event Rule Set User Selection relationship:

WHERE ( ( Version Data Selection ) (First Event Rule Set User Selection <AND>/<OR>/<NONE>=<AND>) ( Event Rule Set User Selection ) ) AND ( JOIN )

Examples

First Event Rule Set User Selection set to <AND>

SELECT T0.MCMCU, T0.MCSTYL, T0.MCDC, T0.MCLDM, T0.MCCO, T0.MCAN8, T0.MCAN8O, T0.MCCNTY, T0.MCADDS, T0.MCFMOD, T0.MCDL01, T0.MCDL02, T0.MCDL03, T0.MCDL04, T0.MCRP01, T0.MCRP02, T0.MCRP03, T0.MCRP04, T0.MCRP05, T0.MCRP06, T0.MCRP07, T0.MCRP08, T0.MCRP09, T0.MCRP10, T0.MCRP11, T0.MCRP12, T0.MCRP13, T0.MCRP14, T0.MCRP15, T0.MCRP16, T0.MCRP17, T0.MCRP18, T0.MCRP19, T0.MCRP20, T0.MCRP21, T0.MCRP22, T0.MCRP23, T0.MCRP24, T0.MCRP25, T0.MCRP26, T0.MCRP27, T0.MCRP28, T0.MCRP29, T0.MCRP30, T0.MCTA, T0.MCTXJS, T0.MCTXA1, T0.MCEXR1, T0.MCTC01, T0.MCTC02, T0.MCTC03, T0.MCTC04, T0.MCTC05, T0.MCTC06, T0.MCTC07, T0.MCTC08, T0.MCTC09, T0.MCTC10, T0.MCND01, T0.MCND02, T0.MCND03, T0.MCND04, T0.MCND05, T0.MCND06, T0.MCND07, T0.MCND08, T0.MCND09, T0.MCND10, T0.MCCC01, T0.MCCC02, T0.MCCC03, T0.MCCC04, T0.MCCC05, T0.MCCC06, T0.MCCC07, T0.MCCC08, T0.MCCC09, T0.MCCC10, T0.MCPECC, T0.MCALS, T0.MCISS, T0.MCGLBA, T0.MCALCL, T0.MCLMTH, T0.MCLF, T0.MCOBJ1, T0.MCOBJ2, T0.MCOBJ3, T0.MCSUB1, T0.MCTOU, T0.MCSBLI, T0.MCANPA, T0.MCCT, T0.MCCERT, T0.MCMCUS, T0.MCBTYP, T0.MCPC, T0.MCPCA, T0.MCPCC, T0.MCINTA, T0.MCINTL, T0.MCD1J, T0.MCD2J, T0.MCD3J, T0.MCD4J, T0.MCD5J, T0.MCD6J, T0.MCFPDJ, T0.MCCAC, T0.MCPAC, T0.MCEEO, T0.MCERC, T0.MCUSER, T0.MCPID, T0.MCUPMJ, T0.MCJOBN, T0.MCUPMT, T1.GMCO, T1.GMAID, T1.GMMCU, T1.GMOBJ, T1.GMSUB, T1.GMANS, T1.GMDL01, T1.GMLDA, T1.GMBPC, T1.GMPEC, T1.GMBILL, T1.GMCRCD, T1.GMUM, T1.GMR001, T1.GMR002, T1.GMR003, T1.GMR004, T1.GMR005, T1.GMR006, T1.GMR007, T1.GMR008, T1.GMR009, T1.GMR010, T1.GMR011, T1.GMR012, T1.GMR013, T1.GMR014, T1.GMR015, T1.GMR016, T1.GMR017, T1.GMR018, T1.GMR019, T1.GMR020, T1.GMR021, T1.GMR022, T1.GMR023, T1.GMOBJA, T1.GMSUBA, T1.GMWCMP, T1.GMCCT, T1.GMERC, T1.GMHTC, T1.GMQLDA, T1.GMCCC, T1.GMFMOD, T1.GMUSER, T1.GMPID, T1.GMJOBN, T1.GMUPMJ, T1.GMUPMT FROM DEVDTA.F0006 T0,DEVDTA.F0901 T1 WHERE ( ( T1.GMMCU = ' 000000000' AND T1.GMOBJ BETWEEN '1000' AND '6000' ) AND ( T1.GMPEC = 'N' OR T1.GMPEC = 'B' ) ) AND ( T0.MCMCU=T1.GMMCU ) ORDER BY T1.GMMCU ASC,T1.GMOBJ ASC

First Event Rule Set User Selection set to <OR>

SELECT T0.MCMCU, T0.MCSTYL, T0.MCDC, T0.MCLDM, T0.MCCO, T0.MCAN8, T0.MCAN8O, T0.MCCNTY, T0.MCADDS, T0.MCFMOD, T0.MCDL01, T0.MCDL02, T0.MCDL03, T0.MCDL04, T0.MCRP01, T0.MCRP02, T0.MCRP03, T0.MCRP04, T0.MCRP05, T0.MCRP06, T0.MCRP07, T0.MCRP08, T0.MCRP09, T0.MCRP10, T0.MCRP11, T0.MCRP12, T0.MCRP13, T0.MCRP14, T0.MCRP15, T0.MCRP16, T0.MCRP17, T0.MCRP18, T0.MCRP19, T0.MCRP20, T0.MCRP21, T0.MCRP22, T0.MCRP23, T0.MCRP24, T0.MCRP25, T0.MCRP26, T0.MCRP27, T0.MCRP28, T0.MCRP29, T0.MCRP30, T0.MCTA, T0.MCTXJS, T0.MCTXA1, T0.MCEXR1, T0.MCTC01, T0.MCTC02, T0.MCTC03, T0.MCTC04, T0.MCTC05, T0.MCTC06, T0.MCTC07, T0.MCTC08, T0.MCTC09, T0.MCTC10, T0.MCND01, T0.MCND02, T0.MCND03, T0.MCND04, T0.MCND05, T0.MCND06, T0.MCND07, T0.MCND08, T0.MCND09, T0.MCND10, T0.MCCC01, T0.MCCC02, T0.MCCC03, T0.MCCC04, T0.MCCC05, T0.MCCC06, T0.MCCC07, T0.MCCC08, T0.MCCC09, T0.MCCC10, T0.MCPECC, T0.MCALS, T0.MCISS, T0.MCGLBA, T0.MCALCL, T0.MCLMTH, T0.MCLF, T0.MCOBJ1, T0.MCOBJ2, T0.MCOBJ3, T0.MCSUB1, T0.MCTOU, T0.MCSBLI, T0.MCANPA, T0.MCCT, T0.MCCERT, T0.MCMCUS, T0.MCBTYP, T0.MCPC, T0.MCPCA, T0.MCPCC, T0.MCINTA, T0.MCINTL, T0.MCD1J, T0.MCD2J, T0.MCD3J, T0.MCD4J, T0.MCD5J, T0.MCD6J, T0.MCFPDJ, T0.MCCAC, T0.MCPAC, T0.MCEEO, T0.MCERC, T0.MCUSER, T0.MCPID, T0.MCUPMJ, T0.MCJOBN, T0.MCUPMT, T1.GMCO, T1.GMAID, T1.GMMCU, T1.GMOBJ, T1.GMSUB, T1.GMANS, T1.GMDL01, T1.GMLDA, T1.GMBPC, T1.GMPEC, T1.GMBILL, T1.GMCRCD, T1.GMUM, T1.GMR001, T1.GMR002, T1.GMR003, T1.GMR004, T1.GMR005, T1.GMR006, T1.GMR007, T1.GMR008, T1.GMR009, T1.GMR010, T1.GMR011, T1.GMR012, T1.GMR013, T1.GMR014, T1.GMR015, T1.GMR016, T1.GMR017, T1.GMR018, T1.GMR019, T1.GMR020, T1.GMR021, T1.GMR022, T1.GMR023, T1.GMOBJA, T1.GMSUBA, T1.GMWCMP, T1.GMCCT, T1.GMERC, T1.GMHTC, T1.GMQLDA, T1.GMCCC, T1.GMFMOD, T1.GMUSER, T1.GMPID, T1.GMJOBN, T1.GMUPMJ, T1.GMUPMT FROM DEVDTA.F0006 T0,DEVDTA.F0901 T1 WHERE ( ( T1.GMMCU = ' 000000000' AND T1.GMOBJ BETWEEN '1000' AND '6000' ) OR ( T1.GMPEC = 'N' OR T1.GMPEC = 'B' ) ) AND ( T0.MCMCU=T1.GMMCU ) ORDER BY T1.GMMCU ASC,T1.GMOBJ ASC

First Event Rule Set User Selection set to <NONE>