eGzyl.pl 2 Posted December 15, 2009 hello(P_ - prestashop_)I have porblem with join table.I want join p_product with p_features and p_features_lang and p_features_value_lang.i make: SELECT p.id_product,pl.name AS p_name, pl.link_rewrite, fp.id_feature_value AS f_name, fl.name AS fl_name FROM '._DB_PREFIX_.'product p LEFT JOIN '._DB_PREFIX_.'product_lang pl ON (p.id_product = pl.id_product) INNER JOIN '._DB_PREFIX_.'feature_product fp ON (p.id_product = fp.id_product) INNER JOIN '._DB_PREFIX_.'feature_lang fl ON (fp.id_feature = fl.id_feature) here is all ok but i want some like thatfl.name = fvl.value ( for all feature what i create, where fvl is p_feature_value_lang)for example:name product: capfeature:size = 10height = 20sezon = winter...please help Share this post Link to post Share on other sites