muripoLife/product_set.sql

## readme.md

      
    Raw
  

              readme.md
            
          
yyyymm


2019-01-01


2019-02-01


2019-03-01


2019-04-01


2019-05-01


id


1


2


3


4


5


## product_set.sql
with temp_yyyymm as(
    select left(date, 7) yyyymm from calendar group by 1
),
temp_id as(
    select id from table
)
select
    id,
    yyyymm
from temp_id, temp_yyyymm
;
	with temp_yyyymm as(
	select left(date, 7) yyyymm from calendar group by 1
	),
	temp_id as(
	select id from table
	)
	select
	id,
	yyyymm
	from temp_id, temp_yyyymm
	;