左连接 临时表 查询

左连接 临时表 查询

SELECT

    fp.id, fp.name, fp.price, fp.create_time, fp.create_name, fp.create_id, fp.update_time, fp.update_name, fp.update_id, fp.factory_id, fp.factory_name,

    fp.co1, fp.co2, fp.co3, fp.co4, fp.co5, fp.co6, fp.co7, fp.co8, fp.co9, fp.co10,fppTemp.id factoryProductPriceID ,fppTemp.unit_price factoryProductPriceUnitPrice,

    fppTemp.update_time factoryProductPriceUpdateTime

    FROM ez_factory_product fp

    LEFT JOIN （SELECT * FROM  ez_factory_product_price fpp WHERE fpp.doctor_id = '7234' AND fpp.doctor_type = '1'）as fppTemp ON fp.id = fppTemp.product_id

    WHERE fp.factory_id = '2' AND fp.co2 = '160'