Union query- 9 Queries

[JessieBee]

Hi
I'm really struggling to work a union query. I have 9 queries that I need to have as 1 dataset. I've been putting:

SELECT bookcode, code, propcode, bookdate, status, sdate, fdate, duration, adults, children, babies, pets, holidayprice, hh_net, prop-postcode, customer_postcode, X, Y, Mosaic_UK_Group, Mosaic_UK_Type, Expr1 FROM LateSummer
UNION [ALL]
SELECT bookcode, code, propcode, bookdate, status, sdate, fdate, duration, adults, children, babies, pets, holidayprice, hh_net, prop-postcode, customer_postcode, X, Y, Mosaic_UK_Group, Mosaic_UK_Type, Expr1 FROM SummerHols;

LateSummer and SummerHols are two of the queries.

Does the SQL look wrong?



Thanks!

Jess

[pbaldy]

Try without the brackets around ALL.

[recyan]

In addition to pbaldy's suggestion,

LateSummer and SummerHols are two of the queries.

if possible, see if the 2 queries can be replaced with a single query .

Thanks

[orange]

Using ALL in union queries will select duplicates if they exist.
see
http://www.techonthenet.com/sql/union.php
http://www.techonthenet.com/sql/union_all.php