SELECT O.ID,
       F.CREATEDTIME,
       F.CLIENTUSERNAME,
       F.FOLDERNO,
       O.MATERIALNAME,
       F.WORKSHOPSECTION,
       ''       AS TESTNAME,
       O.REMARKS,
       '☑'      AS A,
       '☑'      AS B,
       '☑'      AS C,
       '化学组' AS TESTGROUP
FROM T_LIMS_ORDER O
         INNER JOIN T_LIMS_FOLDER F ON F.ID = O.FOLDERID