Unanswered: Help updating a table with values from another table.
I really need some help with an update statement in Oracle.
I have 2 tables in an Oracle DB. Table 1 has a structure of
MDW_Year Integer null,
MDW_Month integer null,
MDW_Mth_Desc varchar2(3) null,
MDW_DOW varchar2(12) null,
MDW_Nbr_MCMR integer null,
MDW_Nbr_DCMR integer null,
MDW_Nbr_DOWPCT integer null
I have populated table 1 with a record for the year = 2004, months jan through dec and dow sun through sat for each month. I need to update the field mdw_nbr_dcmr with the value of the field mdwi_nbr_mcmr field from the second table. where table1.year = table2.year and table1.month=table2.month and table1.dow=table2.dow.
Table 2 has a a structure of
MDWI_Year Integer null,
MDWI_Month integer null,
MDWI_DOW varchar2(12) null,
MDWI_Nbr_MCMR integer null
nothing i have done works can someone provide some help.
what I'm trying to do, and maybe not correctly, is summarize information by Year, Month, and Day of the Week ie. Monday. If i use date column i think i'll end up with summarizations by specific date.