Hi Eva,

Although you technically could use a scripting language like python to do this, this would require some significant scripting work depending on the type of join you're trying to do between the two tables. Most of the examples I've seen of people doing this required them to pull down the data into csv files, then have the csv files used in conjunction with something like pandas (http://pandas.pydata.org/pandas-docs/stable/index.html) to do the merging/joining (http://pandas.pydata.org/pandas-docs/stable/merging.html). This information would also be sitting outside of LabKey rather than within the UI, so you wouldn't be able to do anything beyond just looking at the joined data via Python.

Have you considered possibly importing that external table into your LabKey database through an ETL? You could setup a whole unique internal schema in LabKey and a table for this MySQL data that could get updated regularly and thereby allowing you to do everything you want to do within the LabKey UI.

https://www.labkey.org/home/Documentation/wiki-page.view?name=etlTutorial

Regards,

Jon