diff options
Diffstat (limited to 'sqlglot/optimizer/eliminate_subqueries.py')
-rw-r--r-- | sqlglot/optimizer/eliminate_subqueries.py | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/sqlglot/optimizer/eliminate_subqueries.py b/sqlglot/optimizer/eliminate_subqueries.py index 5ae1fa0..728493d 100644 --- a/sqlglot/optimizer/eliminate_subqueries.py +++ b/sqlglot/optimizer/eliminate_subqueries.py @@ -144,8 +144,9 @@ def _eliminate_derived_table(scope, existing_ctes, taken): name, cte = _new_cte(scope, existing_ctes, taken) table = exp.alias_(exp.table_(name), alias=parent.alias or name) - parent.replace(table) + table.set("joins", parent.args.get("joins")) + parent.replace(table) return cte |