left join ¿con cláusulas where?

[helacer]

ya probo con esto?


SELECT ppe.products_extra_fields_id, op.orders_products_id, op.products_id, op.products_name, op.products_model, op.products_price, op.products_tax, op.products_quantity, op.final_price
FROM orders_products op
LEFT JOIN products_to_products_extra_fields ppe ON op.products_id = ppe.products_id AND op.orders_id =3751 AND ppe.products_extra_fields_id =1