表1有二个字段对应表2

   SELECT
    `workStation`.`id`
    , `work`.`TypeName`
    , `work`.`MONO`
    , `work`.`QTY`
    , `workStation`.`DoneCount`
    , `workStation`.`HostName`
    , `ns_user_binding`.`CNName`
    , `workStation`.`QCID`
    , (SELECT `CNName` FROM `ns_user_binding` WHERE `id` =`workStation`.`QCID`) AS `QCID`
    , `workStation`.`BudgetCount` AS 预数量
    ,`tasklist`.`DoneCount`
  FROM
    `work`
    INNER JOIN `tasklist`
      ON (`work`.`Order` = `tasklist`.`FromOrder`)
    INNER JOIN `workStation`
      ON (`tasklist`.`uuidTaskList` = `workStation`.`uuidTaskList`)
    INNER JOIN `ns_user_binding`
     ON (`workStation`.`UserName`=`ns_user_binding`.`UserName`)
  WHERE `workStation`.`HostName` = '3CL1201'
    AND `workStation`.`Status` = 'OPEN'
  ORDER BY `workStation`.`id` DESC ;