SELECT a.art_id AS art_id, a.ecs_id AS ecs_id, a.parent_id AS parent_id, a.primarytext AS primarytextutprisTodate, pp.price AS innpris, pp.fromdate AS innprisFromdate, pp.todate AS innprisTodate
LEFT JOIN ecs_purchaseprice pp ON a.art_id=pp.a
请描述您的问题地址:https://cloud.tencent.com/act/first_purchase?utm_source=portal&utm_medium=banner&utm_campaign=firstpurchase&utm_term=0109Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36