An error occurred executing the following query, and page execution has been terminated.
SELECT c.CAT_ID, c.CAT_Name1, p.CAT_ID As ParentID FROM (tblCactuShop1Categories AS c LEFT OUTER JOIN tblCactuShop1CategoryHierachy ch ON c.CAT_ID = ch.CH_ChildID) LEFT OUTER JOIN tblCactuShop1Categories p ON ch.CH_ParentID = p.CAT_ID WHERE c.CAT_Live='y' AND c.CAT_CustomerGroupID IN (0,0) ORDER BY c.
Error Description : [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '.'.
Page of error : /search.asp
Query String :