mysql #1064 error
If I execute this command in my pc running netserver it works, but when I try to execute it at the university server it gives me the syntax error:
SELECT pd.pd_id, pd.pd_name, pd.pd_price, pd.pd_thumbnail, pd.pd_qty,
c.cat_id, o.od_id, o.pd_id
FROM tbl_product pd, tbl_category c , tbl_order_item o
WHERE (pd.cat_id = c.cat_id) AND (pd.pd_id = o.pd_id)
and c.cat_parent_id IN (select cc.cat_parent_id from
tbl_category cc WHERE cc.cat_id = 19)
ORDER BY pd.pd_name;
What is wrong?
Armando
|