General information
Category:
Coding, syntax & commands
Title:
VFP6 SQL Remote View Problem
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only