NVL (exam_item item_name, ' ') as check project
- the sum (dict_exam_item workload) as workload,
- the sum (cost) as "amount (RMB)
"The from v_exams, exam_staff exam_item, dict_exam_item
Where v_exams. Exam_No=exam_staff. Exam_No
And v_exams. Exam_no=exam_item. Exam_no
And exam_item. Item_code=dict_exam_item. Item_code
And v_exams. Exam_class='ultrasonic'
And exam_status & gt;
='60'And exam_item. Item_name is not null
And v_exams. Exam_Class='ultrasonic'
And v_exams. Exam_Date='2019-05-31'
- group by exam_staff staff_name, exam_item. Item_name
The order by exam_staff staff_name, exam_item item_name
CodePudding user response:
Visual inspection: no problem, the original poster is a snapshot,CodePudding user response:
Where the order by using exam_item. Item_name into NVL (exam_item item_name, ' '), try