On 4/30/20 5:36 PM, Gianluigi wrote:
> Hi,
> Can you pass a SELECT Aliases query to the DataSource.Table of gb.db.form, as SELECT column_name AS alias_name FROM table_name;
> or pass multiple tables with Inner Join ?
> Because I can't.
>> Regards
> Gianluigi
On a Wordpress database, I was able to use the following successfully:
"SELECT option_id, option_name AS my_name FROM wp_options order by option_id asc"
I did not try a JOIN.
--
Lee