Thanks !

By the way could any of you help me make my update sql code work please as for i receive the following error message: Line 30: Incorrect syntax near ')'.

UPDATE...

Thanks for the fast reply djj. I also found out the following suggestions on another forum:

I will first try the following logic:

SELECT

Parts.SuppliersName

,InternationalSuppliers.Name

,Parts.SuppliersLongName

,InternationalSuppliers.LongName

FROM

dbo.Parts

INNER JOIN dbo.InternationalSupplier ON...