Information générale
Catégorie:
Codage, syntaxe et commandes
>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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement