>I have a 3 file query. For every record in file A, there is a record in file B, but only some records in files A/B have a record in file C.
>
>In VFP 6 I had a query with a left outer join to file C and a where filter on file C:
>
>select ....
> from A join B on A.memb_no = B.memb_no ;
> left outer join C on A.memb_no = C.memb_no ;
> where C.lastpaid > dlDate
>
>This produced the result I wanted: All records from file A where there was either no record in file C or there was a record in file C and field lastpaid had a date later than variable dlDate.
>
>In VPF 8, the result is different. I lose all the records from file A where there is no record in file C.
>
>I can see now that my SQL syntax was sort of ambiguous, but what should it be? Is it possible to get what I want in a single SQL statement?
I'm not sure this query would bring in all records from A,B even in VFP5. Anyway try this:
select ....
from A join B on A.memb_no = B.memb_no ;
left outer join C on A.memb_no = C.memb_no ;
and C.lastpaid > dlDate
Cetin