Hi,
> select a.1, a.4, a.5, a.6, a.7, a.8, a.9, b.1, b.5, b.6, b.7, b.8, ;
> c.2, d.2, e.2, f.2, f.3 ;
> from force db!a inner join db!b inner join db!c ;
> inner join db!d inner join db!e inner join db!f ;
> on f.1 == b.4 on e.1 == a.3 on d.1 == b.3 ;
> on c.1 == b.2 on b.1 == a.2
if you take a closer look into the complete FROM...INNER JOIN....ON part of that query, you will recognize, that its somehow "twisted".
It looks like a query, that was produced by the VFP Query/View designer. I made the experience, that these queries sometimes bring wrong results, and sometimes couldn't be opened again with the designer. <s>
Try to change that part of the query like this:
...from db!a inner join db!b on b.1 == a.2 ;
inner join db!c on c.1 == b.2 .... and so on
Hope that helps.
Holger Vorberg
Germany