Need help in Update statements with Set for Oracle

[mprahl]

I have this SQL and Oracle says I'm missing a "Select" in it. I'm not sure where to add it. Can someone help answer this.

UPDATE
((TBL4_Reportin g LEFT OUTER JOIN WK1_2_IMPORT ON TBL4_Reporting. EarnCode = WK1_2_IMPORT.Ea rnCode)
LEFT OUTER JOIN WK1_IMPORT ON TBL4_Reporting. EarnCode = WK1_IMPORT.Earn Code)
LEFT OUTER JOIN WK2_IMPORT ON TBL4_Reporting. EarnCode = WK2_IMPORT.Earn Code
SET
TBL4_Reporting. WK1_2Hours = [WK1_2_IMPORT]![Hours],
TBL4_Reporting. WK1_2ASBP = [WK1_2_IMPORT]![Amount],
TBL4_Reporting. WK1_Hours = [WK1_IMPORT]![Hours],
TBL4_Reporting. WK1_Amt = [WK1_IMPORT]![Amount],
TBL4_Reporting. WK2_Hours = [WK2_IMPORT]![Hours],
TBL4_Reporting. WK2_Amt = [WK2_IMPORT]![Amount];

[chandu031]

Hi,

I found an interesting article on update join views and thought this might be helpful:

http://www.jlcomp.demo n.co.uk/faq/joinview.html