sql join

添加链接描述

SELECT 
aa.platform_reference_price,
aa.recycler_start_price,
bb.start_amount_num
--aa.*,
--bb.*
FROM dw.dw_platform_quotation_recycler_quote_record aa 
INNER JOIN dw.dw_platform_document_product bb
on aa.quote_date=bb.quotation_document_begin_date and aa.product_combine_sku_id =bb.product_combine_sku_id limit 100