Union Query syntax

From: Hoof Hearted (HoofHearted_at_discussions.microsoft.com)
Date: 02/02/05


Date: Wed, 2 Feb 2005 01:43:01 -0800

I want to pull the most recent record from 2 tables with a Union query.
Here's what I thought would work:

Select TOP 1 EntryTime, Windspeed, WindDirection, Temperature FROM
BlackpoolWeather ORDER BY EntryTime Desc
UNION Select TOP 1 EntryTime, Windspeed, WindDirection, Temperature FROM
ManchesterWeather ORDER BY EntryTime Desc

I know its the TOP 1 that causing the problem. So how do I make this work?