query result error
No: 3065
Msg: Expression #1 of ORDER BY clause is not in SELECT list, references column 'cwdb2020.tbl1.docorder' which is not in SELECT list; this is incompatible with DISTINCT
SQL: SELECT DISTINCT tbl1.doccatname, tbl1.docid, tbl1.description, plinks.permalink, plinks.friendlytitle FROM cmsdocumentcategory tbl1 LEFT JOIN permalinks plinks ON plinks.typeid = tbl1.docid AND plinks.type = 'document' WHERE parentid = 498 ORDER BY tbl1.docorder

File and Document Library
Lamp in sunlights
© 2024 Cape Wools SA. All Rights Reserved.
Network & Infrastructure Services by Mars Technologies
Analytics/ Data Services by Web Route
Website Design by Online Innovations