Select query losing records

[pdauction]

Hi,

I have googled this but can't seem to find a solution. Will be really grateful if someone could help on this.

I have a Union query as follows;

SELECT ALL *
FROM 1st_Lives
UNION SELECT ALL *
FROM 2nd_Lives;

1st Lives has 465,414 records and 2nd Lives has 151,852 records.

When I run the query I only get 604,976 records instead of 617,266 (I basically just want to add the two data items together).

Kind Regards

 

[pdauction]

Apologies, I have now fixed this with the following code;

SELECT * FROM 1st_Lives
UNION ALL
SELECT * FROM 2nd_Lives;