Guest_imported
New member
- Jan 1, 1970
- 0
I am using the sql statement below to retrieve the service no that are not exist in assigned_svcno table.
SQL Statement
select disp_s_no from eba.svcno_available s where cust_id='002' and not exists (select service_no from eba.assigned_svcno where cust_id='002' and service_no = s.disp_s_no)
I try to achieve the same result in crystal report but cannot display the service number. I can only get the service no that appeared in both table.
SQL Statement
select disp_s_no from eba.svcno_available s where cust_id='002' and not exists (select service_no from eba.assigned_svcno where cust_id='002' and service_no = s.disp_s_no)
I try to achieve the same result in crystal report but cannot display the service number. I can only get the service no that appeared in both table.