[Gambas-user] DataSource.Table = SELECT...

[T Lee Davidson]

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