You can’t do that from the Ignition side. JDBC simply doesn’t support such operations. You have to query each one separately and use a script to match and combine rows from the two sources into a final output dataset. When emulating a JOIN in a script, it is simplest to put the rows of the smaller source dataset into a python dictionary, keyed on the value or tuple of values needed for the ON condition. Then extract what you need as you iterate through the rows of the larger source dataset.
2 Likes