SQL Server Update Join

Question

UPDATE Tickets
    SET Price = 1.13 * Price
FROM Tickets t
JOIN Flights f ON t.FlightId = f.Id
WHERE f.Destination = 'Carlsbad'

UPDATE Tickets
    SET t.Price = 1.13 * t.Price
FROM Tickets t
JOIN Flights f ON t.FlightId = f.Id
WHERE f.Destination = 'Carlsbad'

The first code is working perfectly fine, but when I try the second, I get the error

The multi-part identifier "t.Price" could not be bound.

What's the problem? I think it's more clear the second way.

Does this answer your question? SQL update query using joins — forpas
– forpas, Commented Feb 22, 2022 at 19:51

Nafis Islam · Accepted Answer · 2020-07-13 20:32:52Z

2

UPDATE t
    SET t.Price = 1.13 * t.Price
FROM Tickets t
JOIN Flights f ON t.FlightId = f.Id
WHERE f.Destination = 'Carlsbad'

You need to use t (table alias)

answered Jul 13, 2020 at 20:30

Nafis Islam

1,5172 gold badges16 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you! I didn't know that.