Respected Sir,
I am working as a System Analyst for Topworld Inftech, India. We are using php-mysql
for our web based projects. I found a problem while i am using the following Query.
SQL-query:
select distinctrow c.name, p.cat_id, p.prd_id, p.name, p.description, p.title, p.price
from categories c inner join(products p left join(products a
left join products b on a.prd_id = b.prd_id)on p.prd_id = a.prd_id)
on c.cat_id = p.cat_id where lower(p.name) like lower('%a%') or
lower(a.title) like lower('%a%') or lower(b.description)
like lower('%a%');
Error
You have an error in your SQL syntax near 'inner join(products p left join(products a
left join products b on a.prd_id = ' at line 2
Can u tell me how to solve this problem. Waiting eagerly for your reply.
With Regards,
V.Satakopan,
System Analyst,
Topworld Inftech,
No.1, Santhome High Road,
Chennai - 600 004,
Tamil Nadu,
India.
