Select query between database table and uipath datatable

[tutu1 (Tina)]

Hi, I think my problem is better explained with an example:

If I have a table in a mysql database called MyTable, with columns MyColumn1 and MyColumn2, and a datatable in UiPath called UiPathDataTable, with columns Data1 and Data2, can I do a query like this on uipath?

Select *
From MyTable
Inner Join UiPathDataTable
On MyColumn1 = Data1

[ushu (Usha kiranmai)]

Please go through below post

SQL Execute Query Syntax for INNER JOIN tables

Couldn’t find anything on this topic… I need to perform a SQL query on a database, inner joining several datatabels. Db connection is working fine, but I’m getting a syntax error when executing the query: "Execute Query: ERROR [HY000] [Data Direct][ODBC Progress OpenEdge Wire Protocol driver] [OPENEDGE] Syntax error in SQL statement at or about “[dtMain] INNER JOIN [dt1] ON [dt2” (10713) Query looks like this: SELECT dt1, dt2, dt3, dt4, dt5, dt6, dt7, dt8, dt9, dt10, dt11,dt12 FROM dtMain …