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](https://stackoverflow.com/questions/982919/sql-update-query-using-joins) — forpas, Feb 22 '22 at 19:51

Nafis Islam · Accepted Answer · 2020-07-13T20:32:52.183

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)

edited Jul 13 '20 at 20:32

answered Jul 13 '20 at 20:30

Nafis Islam

1 Answers1