nuBuilder Forum

Posted: **Tue Feb 12, 2013 3:20 pm**

I'll try. Thank you for your suggestion!

Alex

Max

your suggestions works well but I had to discard the use of #browseTable#.
If I insert #browseTable# as the source table name for the form (in the Table field of the form), nuBuilder doesn't read the value of #browseTable# hash variable, but the name #browseTable# itself! And this generates a query like this:

Code: Select all

SELECT '#browseTable#'.* FROM '#browseTable#'

So I tried a code like this:

Code: Select all

nuRunQuery("DROP TABLE IF EXISTS temp_table");
nuRunQuery("CREATE TABLE temp_table SELECT address as adr FROM employees UNION SELECT address as adr FROM customers");

and it works.

Thank you
Alex

Posted: **Thu Feb 14, 2013 1:22 am**

nuBuilder Forum

Display data on a form from multiple tables

Re: Display data on a form from multiple tables

Re: Display data on a form from multiple tables