General information
Category:
Coding, syntax & commands
>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?
Do you still need the filter after the WHERE clause? I don't know about the use of curly braces {}, but you sure don't need them.
Previous
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