I've tried it and it still gives me this msg: ORA-00933: SQL command not 
properly ended.

is there something I'm leaving out that I'm unaware of?

Much thanks for your help.

> try this version
> 
> 
> UPDATE location
> SET	   location.LC_NORTHING =3D postcode.PC_NORTHING
> 	   location.lc_easting =3D postcode.pc_easting
> FROM postcode
> WHERE      location.lc_postcode_out =3D postcode.PC_POSTCODE_OUT
> AND	   location.lc_postcode_in =3D postcode.PC_POSTCODE_IN;
> 
> -----Urspr=FCngliche Nachricht-----
> Von: echioma@h... [mailto:echioma@h...]
> Gesendet am: Dienstag, 17. April 2001 15:20
> An: sql language
> Betreff: [sql_language] Updating columns from columns in another table
> 
> I've been trying for ages to update a table with this bit of code:
> 
> UPDATE location
> SET	   location.LC_NORTHING =3D postcode.PC_NORTHING
> 	   location.lc_easting =3D postcode.pc_easting
> WHERE      location.lc_postcode_out =3D postcode.PC_POSTCODE_OUT
> AND	   location.lc_postcode_in =3D postcode.PC_POSTCODE_IN;
> 
> 
> 
> and keep getting either of these error messages:
> 
> "Invalid column name" or "SQL command not properly ended".
> 
> Could someone please tell me where I'm going wrong (the column names 
> are
> all valid)?  I'm using oracle 8.5.
> 
> Many thanks in advance.
> E.Ukwu
>