Re: Oracle Update Syntax

BS schreef:
> Group,
>
> What is wrong here with the syntaxt can someone help me?
>
> 1 update po_vendors
> 2 set po_vendors.attribute3 = to_char(contractorimport.contractorid)
> 3 from contractorimport , po_vendors
> 4* where po_vendors.num_1099 = contractorsimport.ssnnumber
> SQL> /
> from contractorimport , po_vendors
> *
> ERROR at line 3:
> ORA-00933: SQL command not properly ended
>
> Thanks
>

You miss a select, you should have something along the line of:
update po_vendors
set po_vendors.attribute3 =

   select to_char(contractorimport.contractorid)    from contractorimport
   where po_vendors.num_1099 = contractorsimport.ssnnumber

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...