SELECT *, processString= CASE WHEN process=0 THEN 'a' WHEN process=1 THEN 'b' WHEN process=2 THEN 'c' END FROM bulkYarnSendingSchedule LEFT JOIN (SELECT NAME, CLIENT_ID FROM client ) c ON bulkYarnSendingSchedule.clientId=c.client_Id WHERE orderNo BETWEEN 'CL120001' AND 'CL130004'
SELECT *, CASE process WHEN 0 THEN 'a' WHEN 1 THEN 'b' WHEN 2 THEN 'c' END AS processString FROM bulkYarnSendingSchedule LEFT JOIN (SELECT NAME, CLIENT_ID FROM client ) c ON bulkYarnSendingSchedule.clientId=c.client_Id WHERE orderNo BETWEEN 'CL120001' AND 'CL130004'