This documentation is for WSO2 Stream Processor 4.2.0. View documentation for the latest release.
Stream Processor 4.2.0

All docs This doc
Expand all   Collapse all

Versions Compared

Old Version 4

changes.mady.by.user Rukshani Weerasinha

Saved on

compared with

New Version Current

changes.mady.by.user Rukshani Weerasinha

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following is the query syntax to retrieve events from an existing table. For more information, please refer to Siddhi Query Guide - Join Table.

Code Block
languagesql
from <STREAM_NAME> join <TABLE_NAME>
    on <CONDITION>
select (<STREAM_NAME>|<TABLE_NAME>).<ATTRIBUTE1_NAME>, (<STREAM_NAME>|<TABLE_NAME>).<ATTRIBUTE2_NAME>, ...
insert into <OUTPUT_STREAM>

...