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?
Richard