Hi
I am trying to make a query to update top 50 rows, but can't make it work.
I have an update query working OK, it compares to tables Flightlist and Flight (Unik is the ID), and update the difference.
Code:
UPDATE (SELECT TOP 50 FROM FlightList Where FlightList.Unik = Flight.Unik Order by FlightList.Unik)
AS Flight LEFT JOIN FlightList ON Flight.Unik = FlightList.Unik SET FlightList.Unik = [Flight].[Unik], FlightList.[D-Time] = [Flight].[D-Time], FlightList.[A/C Type] = [Flight].[A/C Type],
What am I doing wrong?