help needed with update under oracle

this is an update statement that came out of access that i need to transfer to oracle
my problem stems from the fact that oracle doesn't allow joins in the update statement.

UPDATE tblCustomer INNER JOIN (Deductees INNER JOIN tblBilling ON Deductees.EmployeeID = tblBilling.BankAccountNumber) ON tblCustomer.CustomerKey = tblBilling.CustomerKey SET Deductees.LastName = [tblCustomer]![LastName], Deductees.FirstName = [tblCustomer]![FirstName], Deductees.CustomerID = [tblCustomer]![CustomerID] WHERE (((Deductees.LastName) Is Null));

i am trying to update table Deductees with the information contained in the other tables

Mark
mark_at_cybertrails.com Received on Thu Jul 08 1999 - 19:18:29 CDT