Currently I am working on a project with two different databases.
The first database is from a ERP system.
The second database is for Ignition.
In the ERP database, a articlecode, articles names and descriptions are stored.
In the Ignition database production information is stored which is refered trough the articlecode.
Now I would like to show the production information and the article information together in 1 table on the screen. However it is only possible to choose one datasource with a sql binding.
Is it possible to ‘Join’ the two tables and show them together in one table?
And how would this be the fastest solution?