The firs one query is 
And the second one is 
Then 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
Solved
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.
+4- Supporter
Best answer by ctredinnick
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 ...
+18- Supporter
- Best Answer
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 ...
+4- Supporter
ctredinnick wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.