LJM
Member SnapshotMember since: 12th May 2009
Verified Customer
35 Questions: see all »
2 Lists see all »
Database Error
SQL: select count(distinct pr.products_id) as total from product_reviews AS pr
left join product_questions_helpful AS pqh on pr.product_reviews_id = pqh.product_questions_id
LEFT JOIN customers AS c USING (customers_id)
WHERE
pr.authorised = 1 AND
pr.product_reviews_type_id = 3 AND
pr.customers_id='101696'
GROUP BY pr.product_reviews_id
Error: Column 'customers_id' in from clause is ambiguous (1052)
URL: www.ethicalsuperstore.com/profile/view_questions/101696/)
Date: Fri, 10 Feb 2012 12:38:02 +0000