how to use 'left join' with multi-condition

Talk is cheap

SELECT id,amount FROM product
LEFT JOIN product_details
    ON  (product.id = product_details.id)
        AND product_details.id=2;

EOF

donate

感谢鼓励