edelmann Posted January 14, 2006 Report Share Posted January 14, 2006 Erst mal Hallo an alle, ich hoffe mir kann jemand helfen: 1054 - Unknown column 'p.products_id' in 'on clause' select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_vpe, p.products_vpe_status, p.products_vpe_value, p.products_discount_allowed, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '2' ORDER BY p.products_price ASC [XT SQL Error] Was bedeutet Das?? Was hab ich falsch gemacht?? :sad: lg Link to comment Share on other sites More sharing options...
mzanier Posted January 14, 2006 Report Share Posted January 14, 2006 http://www.xt-commerce.com/forums/index.ph...77&hl=on+clause ps: bitte das n?chstemal supportanfragen im daf?r vorgesehenen sponsorenbereich stellen. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.