7,713
社区成员
发帖
与我相关
我的任务
分享
SELECT DISTINCT
PDClass.brokerage, PDClass.id, PDClass.class_name, PDClass.id_code
FROM ((order_products INNER JOIN products ON order_products.p_id = products.id)
RIGHT JOIN PDClass ON LEFT(products.class_code, 4) = PDClass.id_code)
WHERE (len(PDClass.id_code) = 4)