SELECT cust_no "Cust_Vend_No", co_code, '0' "Report_Type" from op_cust_mst where delete_mark = 0 union select vendor_no "Cust_Vend_No", co_code, '1' "Report_Type" from po_vend_mst where delete_mark = 0
View Text - HTML Formatted
SELECT CUST_NO "CUST_VEND_NO" , CO_CODE , '0' "REPORT_TYPE" FROM OP_CUST_MST WHERE DELETE_MARK = 0 UNION SELECT VENDOR_NO "CUST_VEND_NO" , CO_CODE , '1' "REPORT_TYPE" FROM PO_VEND_MST WHERE DELETE_MARK = 0