语句是这样的,一个条码信息fcoa_ean表,需要通过里面的ean_sku字段来对应产品信息fcoa_product表里的产品信息,然后产品信息表里又有一些字字段是有从表字段的,如颜色、规格等。SEL...
语句是这样的,一个 条码信息 fcoa_ean 表,需要通过里面的ean_sku字段来对应 产品信息 fcoa_product 表里的产品信息,然后产品信息表里又有一些字字段是有从表字段的,如颜色、规格等。SELECT `fcoa_ean`.ean_ean, `fcoa_ean`.ean_sku, `fcoa_product`.product_kis, `fcoa_product`.product_number, `fcoa_product`.product_item, `fcoa_type`.type_name, `fcoa_product`.product_name, `fcoa_color`.color_name, `fcoa_specification`.spec_name, `fcoa_sku`.sku_date FROM fcoa_ean LEFT JOIN `fcoa_sku` ON `fcoa_ean`.ean_sku = `fcoa_sku`.sku_sku LEFT JOIN `fcoa_product` ON `fcoa_sku`.sku_product_id = `fcoa_product`.product_id LEFT JOIN `fcoa_color` ON `fcoa_sku`.sku_color = `fcoa_color`.color_id LEFT JOIN `fcoa_specification` ON `fcoa_sku`.sku_spec = `fcoa_specification`.spec_id请帮忙优化一下语句,谢谢! LEFT JOIN `fcoa_type` ON `fcoa_product`.product_type = `fcoa_type`.type_id WHERE `fcoa_ean`.ean_sku IS NOT NULL ORDER BY `fcoa_ean`.ean_id LIMIT
展开