Internal error

DEFRST\\\: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'And'. -2147217900 0 Microsoft OLE DB Provider for ODBC Drivers at   
 SQL is SELECT tblCategories.NodeText, tblCategories_1.NodeText AS ParentNodeText, tblCategories_1.NodeID AS ParentNodeID, tblCategories_2.NodeID AS GrandParentNodeID, tblCategories_2.NodeText AS GrandparentNodeText, tblCategories_3.NodeID AS GreatGrandparentNodeID, tblCategories_3.NodeText AS GreatGrandparentNodeText FROM ((tblCategories LEFT JOIN tblCategories AS tblCategories_1 ON tblCategories.ParentID = tblCategories_1.NodeID) LEFT JOIN tblCategories AS tblCategories_2 ON tblCategories_1.ParentID = tblCategories_2.NodeID) LEFT JOIN tblCategories AS tblCategories_3 ON tblCategories_2.ParentID = tblCategories_3.NodeID WHERE (((tblCategories.NodeID)= And (tblCategories.NodeID)<>0));