INNER JSON 进行内连接
SELECT
miulee.ranking,
miulee.BSRDate,
miuleesku.productname,
miuleesku.Bigcategoryname
FROM
miulee
INNER JOIN miuleesku ON miulee.asin = miuleesku.asin
DISTINCT进行去重,ORDER BY进行排序
SELECT DISTINCT
*
FROM
(
SELECT
miulee.ranking,
miulee.BSRDate,
miuleesku.productname,
miuleesku.Bigcategoryname
FROM
miulee
INNER JOIN miuleesku ON miulee.asin = miuleesku.asin
) miuleedeal
ORDER BY
BSRDate