I have a system about to go live, and just discovered a bug caused by the transition from VFP6 to VFP9. I've created a short piece of code that shows the problem:

OPEN DATABASE ....
CREATE SQL VIEW xview ;
AS select * from company_list ;
union select * from division_list ;
union select * from department_list ;
union select * from location_list
USE cddl2
BROWSE

In VFP9 I get an empty browse, in VFP7 it displays correct results

In VFP9, if I USE each table prior to the view, it works - e.g.
USE company_list IN 0
USE division_list IN 0
USE department_list IN 0
USE location_list IN 0