nuBuilder Forum

I want to create a temporary table to browse a concatenated value from multiple rows from another tableg.
1. I created in php a #TABLE_ID# 2 . then I added suprafata_test to the browse table 3. It doesnt work I am sure that I doing something wrong .......... can someone explain me how it works ?
Thank`s
Ovidiu

Hi Ovidiu,

In your SQL Builder, you will also need to add " #TABLE#.* " from #TABLE_ID#" in your SELECT statement because the program needs to know which table the 'suprafata_test' is coming from.

I cannot see the whole SELECT statement in the second picture you sent but this is what I can show to make it look complete.
SELECT
#TABLE#.*,
lucrare.*,
adresa.*,
terad.*,
localit.*,
strada.*,
lucrare_imobil.*
FROM
#TABLE_ID#,
lucrare,
adresa,
terad,
localit,
strada,
lucrare_imobil

Hope this helps!

tovidiu,

You need to show us the whole SQL statement you're having a problem with.

Steven