Listing 2803
Followup to listing-2802.sql, submitted by fdsf.
Submitted by anonymous user, 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`)