记录sql

 

1、join

select * from sku
inner join spu on sku.spu_id = spu.id and spu.site_name = 'moosejaw'
where sku.last_fetch_time < '20170810' and sku.last_fetch_time > '20170809'
ORDER BY `sku`.`size` ASC