Hello,
Would it be possible to add the area from TR_GEO_AREA to Output Sets?
Any suggestions...
Thank you very much in advance.
Vicky
I tried to add a new output element in tr_quesry_element. The problem is in the column Data From – The table or view name from which the data is pulled must contain a column called customer_no. I want to pull data from tr_geo_area, which doesn’t have customer_no.
I use Description as Data select , and (select * from t_address a JOIN tr_geo_area b ON a. geo_area = b.id) as Data From in tr_quesry_element
When I execute an Output Set report(located in the Lists and Output Sets report folder), I would get an error message…
Any suggestions. …
Thank you very much in advance
did you copy the "data from" directly?
looks like there might be an extra space in error here "ON a. geo_area"
between a. and geo_area
Hello Ryan, Thank you for your help.