Hi everybody!
I have a report from relational DB, where I outer join 2 queries, one of them is an SQL query(don't know if this is relevant or not).
In the join query, I use "if...else" to fill data.
The data is fine, however on the report I get 2 sections - first is cross joined data from both queries. Second is the "outer" part.
I can't put it together :(
Any suggestions?
Thanks!
Casting all data items to the same data type worked 8)