[EMAIL PROTECTED] wrote:
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and p.prod
Hi,
I resolve my problem...
select count(p.products_id) as total from products_description pd,
products p left join manufacturers m using (manufacturers_id),
products_to_categories p2c left join specials s using (products_id)
where p.products_status = '1' and p.products_id = p2c.products_id a
[EMAIL PROTECTED] wrote:
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near '.manufacturers_id = m.manufacturers_id )
LEFT JOIN specials s
USING ( p.produc' at line 4
What's the error in the query?!!?
Hi,
i have a problem, with my one query, this query is OK, in mysql 3.23,
but i update my database to mysql 5.0 and one query having a error
SELECT count( p.products_id ) AS total
FROM products_description pd, products p, products_to_categories p2c
LEFT JOIN manufacturers m
USING ( p.manufac