UPDATE query using a subquery

Hello everyone,

I have searched but couldn't find something similiar to my issue.

This is my table structure:
CREATE TABLE [CARS] (
[id] [int] NOT NULL ,
[name] [char] (10),
[brand] [char] (10),
[model] [char] (10),
CONSTRAINT [PK_CARS] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO

I want to perform an UPDATE on the [CARS].[brand] column. The logic
behind the update is that the brand depends on the the model of the
car.

To do the update, I first have to query another table:

SELECT A.model, B.brand
FROM ...
etc.
(the result gives 10 unique models and 3 unique brands - each model
belongs to one of the 3 brands)

How do I now incorporate this (sub-)query into the UPDATE query? I.E.
How do I update [CARS].[brand] depending on the result of the query?

Many thanks in advance!

On Jan 11, 8:40 am, Jean wrote:
> Hello everyone,
>
> I have searched but couldn't find something similiar to my issue.
>
> This is my table structure:
> CREATE TABLE [CARS] (
> [id] [int] NOT NULL ,
> [name] [char] (10),
> [brand] [char] (10),
> [model] [char] (10),
> CONSTRAINT [PK_CARS] PRIMARY KEY CLUSTERED
> (
> [id]
> ) ON [PRIMARY]
> ) ON [PRIMARY]
> GO
>
> I want to perform an UPDATE on the [CARS].[brand] column. The logic
> behind the update is that the brand depends on the the model of the
> car.
>
> To do the update, I first have to query another table:
>
> SELECT A.model, B.brand
> FROM ...
> etc.
> (the result gives 10 unique models and 3 unique brands - each model
> belongs to one of the 3 brands)
>
> How do I now incorporate this (sub-)query into the UPDATE query? I.E.
> How do I update [CARS].[brand] depending on the result of the query?
>
> Many thanks in advance!

UPDATE Cars SET Brand = (SELECT Brand FROM OtherTable WHERE <your join
condition here>)