I am trying to build a remote view on a VFP6 DBC.
I want to pull in all the records from a parent
table, and I want to attach a field to each
record that is the sum of records in a child table.
Here's the code:

SELECT Donor.* , sum(nOrdr_Pri) as Donatns_to_Date;
FROM {Orditem FULL JOIN Donor ;
ON Orditem.cdonor_no = Donor.cdonor_no };
WHERE Orditem.cdonor_no = Donor.cdonor_no;
ORDER BY Donor.cdonor_no

Why am I getting an error at the "ON" line?