Named query multiple DB

Ignition
1

Would it be possible to do a named query with select from multiple database connection?

1 Like
2

I have not tried this out yet in Ignition but you should be able to this like:

SELECT database1.table1.field1,
database2.table1.field1
FROM database1.table1,
database2.table1

and for more information this link should provide you with what you need:
https://www.navicat.com/en/company/aboutus/blog/1059-how-to-query-across-multiple-databases

3

Not simultaneously, no. Individually, yes. (You can make a parameter that chooses the database connection at runtime.)

4

Hi @pturmel,

always the same that answer the questions :wink:
That's what i thought.
Thx for the help