SQL-crossjoin
1人あたりに3枚の期限違いのクーポン発行するsql作るとかに役立つb
select tmp1.id tmp2.epxired from user as tmp1 cross join ( select '2018-01-31' as expired union all select '2018-02-28' as expired union all select '2018-03-31' as expired ) as tmp2;
1人あたりに3枚の期限違いのクーポン発行するsql作るとかに役立つb
select tmp1.id tmp2.epxired from user as tmp1 cross join ( select '2018-01-31' as expired union all select '2018-02-28' as expired union all select '2018-03-31' as expired ) as tmp2;