Question about UNION

[Ruslan Zasukhin]

On 4/1/05 12:24 AM, "Gregory Kowalski" <gregkowalski at earthlink.net> wrote:

> Hi,
> 
> I'm using V4MD  1.1 MAC OSX and would like to know if you can use UNION.

Wait a moment.

You use 1.11 ?

But it do not support UNION and other new features of 2.0.


> I tried but keep getting bad results.
> 
> For example:
> 
> aTable
>   fieldone       fieldtwo
>   1001             1004
> 
> 
> 
>   bTable
> fieldthree     fieldfour
>   1003             1004
> 
> The following syntax:
> 
> Select * FROM aTable where fieldtwo = 1004 UNION select * from bTable
> where fieldfour = 1004
> 
> gives me a result of one record instead of two.
> 
> If union doesn't work, what are my options to query several tables -
> besides having to create several cursors, of course.
> 
> Thanks for any help


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]