Problem In running the query!
Hi All,
1054 - Unknown column 'p.manufacturers_id' in 'on clause'
select count(*) as total from oc_products p, oc_products_description pd, oc_specials s, oc_products_to_categories pc LEFT JOIN oc_manufacturers m ON m.manufacturers_id = p.manufacturers_id LEFT JOIN oc_networks n ON n.network_id = p.network_id where p.products_status = '1' and s.products_id = p.products_id and p.products_id = pd.products_id AND p.products_id = pc.products_id and pd.language_id = '1' and s.status = '1' and pc.categories_id = 23
wats wrong in the query,
its workin good in server which has mysql 4... some thing and i have in my local server mysql 5...some thing
plz reply ....
Subject
Written By
Posted
Problem In running the query!
February 17, 2006 12:56AM
February 17, 2006 07:53AM
February 19, 2006 10:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.