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

rudy r937 at interlog.com
Mon Oct 21 19:37:07 CDT 2002


> 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




More information about the thelist mailing list