我有2个查询：

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

case_id,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,case_id,x


FROM table_2

WHERE create_date between TO_DATE ('2020/01/01','YYYY/MM/DD')

所以基本上我需要表中的所有信息，case_id是table_1上的主键。如何加入他们以接收所有数据并仅使用table_1中的WHERE？

PS：表格已在redshift上启用频谱

我尝试了

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语句上遇到了错误