Listing 2802
Submitted by fdsf, 20 April 2010
SET @suma_prod:=ProductStock.stock_1+ProductStock.stock_8 SELECT @suma_prod, (suma_prod * Product.price1) as total_prod, ProductStock.stock_8, ProductStock.stock_1 FROM `products` AS `Product` LEFT JOIN `suppliers` AS `Supplier` ON (`Product`.`supplier_id` = `Supplier`.`id`) LEFT JOIN `product_stocks` AS `ProductStock` ON (`ProductStock`.`product_id` = `Product`.`id`)