Union Query Problem

[turtle]

I need to make a union query that returns the results of 2 queries
without combining any fields.
Let me give you an example

Query1
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 0 Electrical Eng.

Query2
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 0 10 Mech Eng

I want the query to show both records but it tries to put them
together if there is no budget. The query returns the following:

Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 10 Mech Eng

Obviously this doesn't work because the budget was for a Elec Eng and
not a Mech eng.
Any help would be great...
Here is my SQL code...

SELECT [workorder],[sequence],[budget],[sumofhrs],[jobcode],[link],[sequence
description],[job category2],[employee category]

from [allbudgetlabor]

UNION select ALL [wonumber],[sequence],[budget],[sumofhrs],[job],[link],[sequence
description],[job category2],[employee category]

from [alllaborbudget];

[John Winterbottom]

"turtle" <ko****@vistacontrols.com> wrote in message
news:58**************************@posting.google.c om...

I need to make a union query that returns the results of 2 queries
without combining any fields.
Let me give you an example

Query1
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 0 Electrical Eng.

Query2
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 0 10 Mech Eng

I want the query to show both records but it tries to put them
together if there is no budget. The query returns the following:

Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 10 Mech Eng

Obviously this doesn't work because the budget was for a Elec Eng and
not a Mech eng.
Any help would be great...
Here is my SQL code...

try UNION ALL instead of UNION

[turtle]

John,
Thanks, but I did try union all and did not get all the records... it
seemed to combine the data.

"John Winterbottom" <as******@hotmail.com> wrote in message news:<2h************@uni-berlin.de>...

"turtle" <ko****@vistacontrols.com> wrote in message
news:58**************************@posting.google.c om...

I need to make a union query that returns the results of 2 queries
without combining any fields.
Let me give you an example

Query1
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 0 Electrical Eng.

Query2
Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 0 10 Mech Eng

I want the query to show both records but it tries to put them
together if there is no budget. The query returns the following:

Job WorkOrder Sequence Budget Actuals Employee_Category
1 A000 1000 10 10 Mech Eng

Obviously this doesn't work because the budget was for a Elec Eng and
not a Mech eng.
Any help would be great...
Here is my SQL code...

try UNION ALL instead of UNION