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 = 12 ORDER BY tbl1.docorder