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
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
