Andrew
asked on
UPDATE JOIN multiple tables
Hello,
I am trying to update [SeedTracker].[dbo].[DBLog NonResInt] .Cassava (bit datatype) from a bit value from another table [SeedTracker].[dbo].[Locat ion].Cassa va joined by DBLogNonResint.Location = Location.Description. If the value in Location.Cassava is True then update the DBLogNonResInt.Cassava to True otherwise update to FALSE.
My latest failed attempt:
I am trying to update [SeedTracker].[dbo].[DBLog
My latest failed attempt:
UPDATE
[SeedTracker].[dbo].[DBLogNonResInt]
SET
Cassava = 0.0160
FROM
[SeedTracker].[dbo].[DBLogNonResInt] nr
INNER JOIN
[SeedTracker].[dbo].[Location] l
ON
nr.Location = l.[Description]
WHERE
l.Cassava = 1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry, forgot the "false" part. try this:
UPDATE [SeedTracker].[dbo].[DBLogNonResInt]
SET [SeedTracker].[dbo].[DBLogNonResInt].Cassava=
(
CASE
WHEN
(t2.Cassava=True)
THEN
t2.Cassave
ELSE
False
END
)
FROM [SeedTracker].[dbo].[Location] as t2
WHERE [SeedTracker].[dbo].DBLogNonResint.Location = t2.Description
ASKER
It's ok, I got it. Thanks!
or
UPDATE [SeedTracker].[dbo].[DBLogNonResInt]
SET [SeedTracker].[dbo].[DBLogNonResInt].Cassava=
(
CASE (t2.Cassava)
WHEN TRUE THEN t2.Cassava
ELSE
False
END
)
FROM [SeedTracker].[dbo].[Location] as t2
WHERE [SeedTracker].[dbo].DBLogNonResint.Location = t2.Description
ASKER