>
> SELECT *
> FROM
> categories ec,
> products ep,
> vendors ev
> WHERE
> ep.prd_cat_id=ec.cat_id AND
> ep.prd_ven_id=ev.ven_id AND
> ep.prd_active > 0 AND
> ec.cat_active > 0 AND
> ev.ven_active > 0 AND
> ep.prd_price > 0 AND
> ev.ven_id=
> GROUP by ec.cat_id ORDER by ec.cat_name
> 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 'GROUP by ec.cat_id ORDER by ec.cat_name' at line 14
Back | 
