>i don't know. should that be entered in the bug list?

>any takes from anyone?

>is it maybe already fixed in a later version? (i work with Vfp6 Service Pack 5)

I run this without problems into VFP6/7/8

CD SYS(2023)
MD dir1
MD dir2
CREATE TABLE dir1\table1 FREE (F1 I , F2 C(1))
INSERT INTO (ALIAS()) VALUES (1,'a')
INSERT INTO (ALIAS()) VALUES (2,'b')
USE
CREATE TABLE dir2\table1 FREE (F1 I , F2 C(1))
INSERT INTO (ALIAS()) VALUES (1,'A')
INSERT INTO (ALIAS()) VALUES (2,'B')
USE
SELECT f2 FROM dir1\table1.dbf tab1 where F1=1;
union;
SELECT f2 FROM dir2\table1.dbf tab2 where F1=1
CLOSE TABLES ALL
DELETE FILE dir1\table1.dbf
DELETE FILE dir2\table1.dbf
RMDIR dir1
RMDIR dir2

you have a repro bug code ?

Fabio