Run jobs with different query transformations conditions.

[system]

120×120 10.4 KB

pushdown_sql(‘Target’, [GENERATABLE REPORTS].[ORDER ID] not in (SELECT [EXCLUDED REPORT ORDERS].[ORDER ID] FROM [EXCLUDED REPORT ORDERS])) If that’s the exact text that you’ve entered then you are missing single quotes around your SQL. Should be: pushdown_sql(‘Target’,’ [GENERATABLE REPORTS].[ORDER ID] not in (SELECT [EXCLUDED REPORT ORDERS].[ORDER ID] FROM [EXCLUDED REPORT ORDERS]) ') ScoobyDoo (BOB member since 2007-05-10)

---

Werner Daehn (BOB member since 2004-12-17)