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
_______________________________________________
Valentina mailing list
Valentina At lists .DO.T macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2005 Gregory Kowalski |
