Re: Multi-Table Query....

you can solve that by using set operator.

select *
from table1
union
select *
from table2;
( you have to match the number of columns of both select. )

:))

Joseph Ranseth <jransethNO_SPAM_at_worldcupfishing.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:93jm5.146$ak3.8156_at_news1.mts.net¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I have 2 tables with similar data, and I need to get the rows from each.
> They are almost identical, they are NOT joined, or related, they just
> contain similar data. How can I get values from both, without having to
> merge the two tables?
> Is this clear enough?
> Thanks in Advance.....
>
> JR
> --
>
>
Received on Tue Aug 15 2000 - 19:03:13 CDT