on 08-07-2014 4:15 PM
I'm trying to use *full* outer join in my Calcultion View based SQL Script. For code excerpt, please see below.
It passes validation and activation, but when executing, it gives the following error:
"Cannot iterate over result set rows: SAP DBTech JDBC: [259]: invalid table name:
[259]: invalid table name: _$_firsttable_2_$: line 1 col 1975 (at pos 1974) at
ptime/query/checker/check_id.cc:427"
It's rather strange, because in the SQL Editor, outside the calculation view, this full outer *works properly*
Additionally, when I use left outer instead of full, the calculation view works.
I'm well aware that I can replace the full join with union between two left joins.
Any ideas would be appreciated.
Thanks in advance
Code Excerpt:
firsttable = select ... (etc.)
secondtable = select ... (etc.)
var_out = select :firsttable.name as name, :secondtable.name as name2
from :firsttable full join :secondtable on :firsttable.name = :secondtable.name
order by :firsttable.name;
Message was edited by: Tom Flanagan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.