Update top 50

[tonyhansson]

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.

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?

[CJ_London]

What does can’t make it work mean? You get an error? Wrong result? Something else? If an error, what is the error message? If wrong result? How is it wrong?

[isladogs]

Answers to all of Ajax's questions would be very helpful.
In the meantime, does this work?

UPDATE FlightList 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]
WHERE FlightList.Unik IN (SELECT TOP 50 FROM FlightList ORDER BY FlightList.Unik)

[tonyhansson]

Hi

Sorry my late answer. Thank you for your answer.

I get a syntax error in Query expression (SELECT TOP 50 FROM FlightList ORDER BY FlightList.Unik) if I use suggestion from isladogs.


If I use my own solution I get: The SELCT statement includes a reserved word or an argument name this is misspelled or missing, or the punctuation is incorrect.


Regards


Tony

[Minty]

As Colin is away I'll endeavour to fix this, try adding Unik to the sub select clause;

(SELECT TOP 50 Unik FROM FlightList ORDER BY FlightList.Unik)

[tonyhansson]

Hi working

thank you to all of you

[isladogs]

Oops. Thanks @Minty