TommyJ
(Real Name: Tommy Jackson)
Member SnapshotName: Tommy Jackson
Location: Newcastle
Member since: 8th June 2007
Ethical Superstore staff
3 e-Views: Helpful (11) Passionate (2) see all »
1 Questions: 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='17806'
GROUP BY pr.product_reviews_id
Error: Column 'customers_id' in from clause is ambiguous (1052)
URL: www.ethicalsuperstore.com/profile/view_questions/17806/)
Date: Fri, 10 Feb 2012 12:25:35 +0000