tjones9034
Programmer
I have a need to populate a table with a large records and lot of colums. I have the following tables involved:
z_location, z_activity and z_invoice.
I added a new column (workorder_no)from z_invoice to z_location.....now having the following colums: Note: Workorder_no is an empty column.
Loccode
Location
Loc_Markup
workorder_no
I need to insert about 137,000 records to this column (workorder_no) in z_location table from the workorder_no values in z_invoice table.
My problem is that I have to retrieve the values of a column (workorder_no in z_invoice table based on this condition: RETRIEVE THE VALUES OF WORKORDER_NO FROM TABLES Z_ACTIVITY AND Z_INVOICE WHERE Z_ACTIVITY.ITEM_NO = Z_INVOICE.ITEM.NO
THEN POPUPULATE THE VALUES OF WORKORDER_NO RETRIEVED FROM THESE TWO TABLES TO THE NEWLY CREATED WORKORDER_NO IN Z_LOCATION TABLE ABOVE.
ANY HELP PLEASE? THANKS.
z_location, z_activity and z_invoice.
I added a new column (workorder_no)from z_invoice to z_location.....now having the following colums: Note: Workorder_no is an empty column.
Loccode
Location
Loc_Markup
workorder_no
I need to insert about 137,000 records to this column (workorder_no) in z_location table from the workorder_no values in z_invoice table.
My problem is that I have to retrieve the values of a column (workorder_no in z_invoice table based on this condition: RETRIEVE THE VALUES OF WORKORDER_NO FROM TABLES Z_ACTIVITY AND Z_INVOICE WHERE Z_ACTIVITY.ITEM_NO = Z_INVOICE.ITEM.NO
THEN POPUPULATE THE VALUES OF WORKORDER_NO RETRIEVED FROM THESE TWO TABLES TO THE NEWLY CREATED WORKORDER_NO IN Z_LOCATION TABLE ABOVE.
ANY HELP PLEASE? THANKS.