Hello,
I am using the SQL Executor to read two tables from oracle using a join.
I would like to use Oracle Spatial Object as Format to have the geometry included.
This is my sql query:
select a.nm, a.fid, b.mlpst, b.feat
from t_csm a
join t_fl b
on a.clss=b.clss
Both table a and b have a geometry (GEOM). When I use SQL Executor - Oracle Spatial Object, how can I know the geometry of which table will be used ? I want it to be the geometry of table b but I don’t how to specify it. The geometries of these two tables are not the same and my next transformer is the neighborfinder so it makes a big different if I use the geometry of table a or table b.Thanks for your help.
