pcsoft.us.windevCopyright 2026, PC SOFT17 Jun 2020 13:07:52 Z16 Jun 2020 23:28:20 ZHi Is there a way to use a data source with a select that returns more than one table? ds is data source sql is string = [ select * from order where id = 1; select * from details where orderid = 1; ] IF HExecuteSQLQuery(ds,hQueryWithoutCorrection,sql) then end however it always returns only the first table; there is something along these lines: ds.table [1] (accessing result of the first select) ds.table [2] (accessing result of the second select) ?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)PeHoBepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67877/read.awp17 Jun 2020 13:07:52 ZHi David, I think you'll need to take a speed course on SQL first. SQL-wise this simply can't work. This however may work: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67877/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67877/read.awpDataSource with multiselectPeHoBepcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67876/read.awp17 Jun 2020 12:57:26 ZHi David, I think you'll need to take a speed course on SQL first. SQL-wise this simply can't work. This however may work: …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67876/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67876/read.awpDataSource with multiselectachiadopcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67875/read.awp17 Jun 2020 12:17:29 ZHi David, I think it is not possible to do that... What you can do is: sql is string = [ select * from order a LEFT OU…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67875/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/67873-datasource-with-multiselect-67875/read.awpDataSource with multiselect