Union Query syntax
From: Hoof Hearted (HoofHearted_at_discussions.microsoft.com)
Date: 02/02/05
- Next message: GW: "copy table structure"
- Previous message: Wendy W: "Data style?"
- Next in thread: Hugo Kornelis: "Re: Union Query syntax"
- Reply: Hugo Kornelis: "Re: Union Query syntax"
- Messages sorted by: [ date ] [ thread ]
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?
- Next message: GW: "copy table structure"
- Previous message: Wendy W: "Data style?"
- Next in thread: Hugo Kornelis: "Re: Union Query syntax"
- Reply: Hugo Kornelis: "Re: Union Query syntax"
- Messages sorted by: [ date ] [ thread ]