MySQL Forums
Forum List  »  General

Error ID: cbe212e1
Posted by: Anthony Apollis
Date: March 13, 2021 04:42PM

Why am i getting this error with this code?
The query returned an error.

Error with SQL statement: 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 'select a.label as 'App Category'
, b.label as 'Menu'
, c.product_uid ' at line 16
Error ID: cbe212e1




select a.label as 'App Category'
, b.label as 'Menu'
, c.product_uid as 'Product UID'
from app_menu_filters a
left join app_menu_filters b on b.parent_uid=a.uid
left join app_menu_filter_products c on b.uid=c.app_menu_filter_uid
where a.status='A' and a.level=1
order by 1,2,3;

Options: ReplyQuote


Subject
Written By
Posted
Error ID: cbe212e1
March 13, 2021 04:42PM
March 13, 2021 07:43PM
March 16, 2021 03:42AM
March 16, 2021 09:04AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.