MySQL Forums
Forum List  »  MySQL Administrator

Query Help
Posted by: Ken Root
Date: August 04, 2009 06:16PM

I purchased a website a year ago and recently moved it to a new host. The new host is running mysql 5.0.81. The old one was running 4.x.x. I have a query that isn't working and I've been trying to figure it out for days now. I would very much appreciate some assistance in what's wrong under version 5. Thank you very much.

select count(p.products_id) as total 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 = '1' and p2c.categories_id = '44'

I'm getting this message: 1054 - Unknown column 'p.products_id' in 'on clause'

Again thank you for your help.

Options: ReplyQuote

Written By
Query Help
August 04, 2009 06:16PM
August 04, 2009 10:16PM

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.