SELECT production.id
, production.name
, production.image
, price_product.product_price AS price
, price_product.product_weight AS weight
FROM production
LEFT OUTER
JOIN prices AS price_product
ON price_product.product_id = production.id
ORDER
BY production.id
@Smolf3d; Don’t forget that any user-submitted data must be sanitized before being allowed anywhere near to the database. The best way is by using prepared statements