Update Query

S

Steve Andler

Hi ;

Is it possible to include more than one update functions
into a one update query . The reason i need that is
beacause there are 15 colums to be updated in a table
which means 15 seperate queries . I have written down my
query as it can only update one column for the moment .

P.S:Update query refers to a reference table for the
colums to be updated.


UPDATE [ExistingTable] INNER JOIN ConversionTable ON
[ExistingTable].[Code 1]=[ConversionTable].[Old Code] SET
[ExistingTable].[Code 1] = [ConversionTable].[NewCode];

Thanks for any help.

Steve
 
Top