Question about UNION

[Gregory Kowalski]

Hi,

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

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

Greg