[thelist] SQL: looking for resources, have one question

> instead of what i'm expecting to get...

  Column 1               |   Column 2
-------------------------+------------------
DataFromTheFirstSelect-1 | DataFromTheSecondSelect-1
DataFromTheFirstSelect-2 | DataFromTheSecondSelect-2
DataFromTheFirstSelect-3 | DataFromTheSecondSelect-3

> what am i doing wrong and what is really happening
> contrary to what i'm thinking should be happening?

chris, those two subqueries in your union query do look like they are
unrelated

could you please say how the columns in all three tables relate?

rudy