이런식일까요?

with tab_a (workday, temp) as (

select '20220201', '가' union all

select '20220202', '나' union all

select '20220203', '다' union all

select '20220204', '라' union all

select '20220205', '마' union all

select '20220206', '바' union all

select '20220207', '사'

),

tab_b (workday, data) as (

select '20220201', 'a' union all

select '20220202', 'b' union all

select '20220203', 'c' union all

select '20220204', 'd' union all

select '20220206', 'e'

)

select a.workday,b.data from tab_a a left outer join tab_b b on a.workday=b.workday 

답변 감사합니다~~