Hi Josh,
No, I don't group anything, and the WHERE clause is no problem (I tried it without WHERE and it goes wrong also).
It looks like:
SELECT Table1.Field1, Table1.Field_2, Table2.Field_etc, Table3.Field_etc,;
FROM Table1 ;
LEFT OUTER JOIN Table2 ;
LEFT OUTER JOIN Table3 ;
etc (six joins) ;
ON Table3.Field_etc = Table1.Field1 ;
ON Table2.Field_etc = Table1.Field2 ;
WHERE This = That ;
INTO CURSOR BadResult
I do this a lot, and never encounter any problems.
Here, the fields of three of the six joined tables are wrong (showing the related values to the first record of the first table).
Any ideas??
Thanks...
Christian Isberner
Software Consultant