Rookie Oracle SQL question

Tom Dunne

This is a tricky one to explain, so bear with me.

I have two queries, A an B, both looking for the same data, under different conditions (so they have common columns). A is horrendous, B is relatively straight forward.

What I want to do is combine the two of them into the one query, I was trying the following:

SELECT * FROM

( <query A>) A,
( <query B>) B

but what I am getting is the two result sets AND'ed together (as you would expect):

A row 1 B row 1
A row 2 B row 1
...
A row n B row 1
A row 1 B row 2
A row 2 B row 2

When in fact I want,

A row 1
A row 2
...
A row n
B row 1
B row 2

Am I completely off the mark on this one? Or is it staring me straight in the face?

pH

select ** query A **
UNION
select ** query B **

Tom Dunne

FFS, I didn't think it would be that easy.

I have a tendancy to over-complicate things.

Edit: Forgot to say thank you.