caner_can Posted November 15, 2007 Report Share Posted November 15, 2007 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join specials s on p.products_id = s.products_id select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, p.products_id, p.products_price, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.manufacturers_id, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, manufacturers m, products p, left join specials s on p.products_id = s.products_id where p.products_status = '1' and pd.products_id = p.products_id and pd.language_id = '2' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '83' [XT SQL Error] Link to comment Share on other sites More sharing options...
ideweb Posted November 17, 2007 Report Share Posted November 17, 2007 Check the manual that corresponds to your MySQL server version for the right syntax to use near 'left join specials s on p.products_id = s.products_id Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.