SELECTT1. Repairno, T1. UNDERTAKER10, T3. FULLNAME asReceivername, T1. Walkdistance, T1. STATUSCODEDATE10 asReceivetime, T8. RepairType, T5. Delivereddate, Case whenT2. Repairno is NULL Then 'No' ELSE 'is a' ENDisinsurance, T2. Fixeddate, T4. FULLNAME asClaimsnname, T2. Totalfee fromRt_repair T1 Left JOINrt_insuranceclaims T2 onT1. Repairno=T2. Repairno andT1. Frameno=T2. Frameno Left JOINCm_staff T3 onT1. UNDERTAKER10=T3. Staffpkid Left JOINCm_staff T4 onT2. Claimsid=T4. Staffpkid Left JOINrt_repairprocess T5 onT1. Repairno=T5. Repairno Left JOINrt_customerwish T6 onT1. Repairno=T6. Repairno Left JOINrt_workcontent T7 onT6. Repairno=T7. Repairno andT6. WISHID=T7. WISHID Left JOINRm_repairtype T8 onT7. Repairtypecode=T8.repairtypecodeWHERET1. Frameno= 'LHGRB186982000004' andSTATUSCODE= ' About'ORDER byRepairnoDESC
The DB2 database uses the WITH statement to separate characters