This content has been marked as final. Show 1 reply
You can refer to the CQL guide: http://docs.oracle.com/cd/E23943_01/apirefs.1111/e12048/queries.htm#CIHEFDGI, where it also describe the inner/outer join.
There is a sample provide call cql provided with the installation where you can test CQL using CEP Visualizer : reference can be found
An easy way to play around with CQL is to build a simple CEP flow : CSV adapter->channelIN->CQL processor->channelOUT-> Listener (define also the needed event type).
Then use the CEP Visualizer to test or create (through wizzard) your CQL statement.