我有两个问题：

/*+ ETLM
{
  depend:{
    replace:[
      {
        name:"table_1"
      }
    ]
  }
}

* /

SELECT 

case_id,
x,
x,
x,
x,
x

FROM table.1

WHERE resolved_date between TO_DATE ('2020/01/01', 'YYYY/MM/DD') and to_date('2020/12/31','YYYY/MM/DD')
AND ASSIGNED_TO_GROUP IN ('First Group')

以及

/*+ ETLM
{
  depend:{
    replace:[
      {
      name:"table_2"
      }
    ]
  }
}

* /

SELECT

x,
x,
x,
case_id,
x,
x

FROM table_2

WHERE create_date between TO_DATE ('2020/01/01', 'YYYY/MM/DD') and to_date('2020/12/31','YYYY/MM/DD')

所以基本上我需要表中的所有信息，case\u id是表1的主键。如何连接它们以接收所有数据并仅使用表1中的where's？
ps：表格在红移时启用光谱
我试过了

Select
x
x
x
FROM table_1 

JOIN table_2 ON table_1.case_id = table_2.case_id
Select 
x
x
x
FROM table_2

Where table_1.resolved_date between ...
AND table_1.assigned_group...

但似乎我在第二个select语句中出错了