|
|
 |
[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 'ORDER BY t2.Name ASC,t1.Name ASC' at line 1SELECT t1.LocationID as LocationID,t1.Name as Name ,t2.Name as ParentName FROM Locations as t1, Locations as t2 WHERE t1.ParentID=t2.LocationID AND t2.Status=1 AND t1.LocationID= ORDER BY t2.Name ASC,t1.Name ASC
| |
