UNION query won't work

[Buttercup]

I am having alot of trouble with a union query Im trying to create.
The bizarre thing is I initially created this query and managed to
save it as a view

SELECT ID, DepartureDate, City, Country, Region,
fkDepartureAirport, CONVERT(MONEY, Price) AS Price, '1' AS Type
FROM dbo.vHoliday
UNION ALL
SELECT ID, ValidTo, DestCity, Country, Region, fkDepartureAirport,
Price, '2' AS Type
FROM dbo.vFlight
However when I tried to update the view to this:
SELECT ID, DepartureDate, fkCity, City, fkCountry, Country,
Region, fkDepartureAirport, CONVERT(MONEY, Price) AS Price, '1' AS
Type
FROM dbo.vHoliday
UNION ALL
SELECT ID, ValidTo, fkCity, DestCity, fkCountry, Country, Region,
fkDepartureAirport, Price, '2'
FROM dbo.vFlight
it comes up with the error: view definition includes no output columns
or includes no items in the from clause.
Any ideas??????

All suggestions appreciated

Ally

[bdjensen]

why 'union all' shouldn't be enough with: 'union'?
/Bjørn
"Buttercup" <al************@hotmail.com> wrote in message
news:3d**************************@posting.google.c om...

I am having alot of trouble with a union query Im trying to create.
The bizarre thing is I initially created this query and managed to
save it as a view

SELECT ID, DepartureDate, City, Country, Region,
fkDepartureAirport, CONVERT(MONEY, Price) AS Price, '1' AS Type
FROM dbo.vHoliday
UNION ALL
SELECT ID, ValidTo, DestCity, Country, Region, fkDepartureAirport,
Price, '2' AS Type
FROM dbo.vFlight
However when I tried to update the view to this:
SELECT ID, DepartureDate, fkCity, City, fkCountry, Country,
Region, fkDepartureAirport, CONVERT(MONEY, Price) AS Price, '1' AS
Type
FROM dbo.vHoliday
UNION ALL
SELECT ID, ValidTo, fkCity, DestCity, fkCountry, Country, Region,
fkDepartureAirport, Price, '2'
FROM dbo.vFlight
it comes up with the error: view definition includes no output columns
or includes no items in the from clause.
Any ideas??????

All suggestions appreciated

Ally