TOPIC: Merging data from two SQL tables

Translated submission in the German forum. You can read the original entry
here
.

Hello,

Is it now possible, or will it be possible in a future version, to open two SQL database tables on the READ side at the same time and merge their data into a single stream? As a reference field, a key exists in both SQL tables.

Thanks and greetings,
Roland

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

If you are using MS SQL Server, you can even merge tables on two different databases in this way, provided the databases exist on the same SQL Server. To achieve this it is necessary to prefix each table name with the database name (punctuated with two dots), for example:.

In a later version of FlowHeater we plan to make it possible to attach several Adapters to both the READ and WRITE sides. These will provide syntax independent connection using specified fields, in a similar way to the above SQL joins.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.