Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • Hi, im trying to replicate some SQL querys from old database in Access. The actual database is in PostGIS. The problem is there a first query, and the second one is making a join from first one's results.

The firs one query is first query 

And the second one is second queryThen I need to do a join with this second query and create a list with the results.

I dont know if with the SQL Executor transformer I can replicate this two querys.

 

Any idea?

 

Thanks

Yeah, you should be able to write it in one statement using a CTE. ie

 

with _FME_Gare_ETC_SQ as (

SELECT ...

)

 

SELECT ...

FROM Gare LEFT JOIN _FME_Gare_ETC_SQ ON ...

Yeah, you should be able to write it in one statement using a CTE. ie

 

with _FME_Gare_ETC_SQ as (

SELECT ...

)

 

SELECT ...

FROM Gare LEFT JOIN _FME_Gare_ETC_SQ ON ...

yeah! thanks @ctredinnick​ I tryed in PGADMIN4 and it works fine. In FME I had to add some file as iniciator for SQL Executor.

 

Thanks

Reply


Community Stats

30,610
Posts
115,981
Replies
38,247
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.