Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help with a View
Message
De
19/10/1998 09:43:41
Alec Dearden
Peterborough Hospitals Nhs Trust
Peterborough, Royaume Uni
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00148071
Message ID:
00148074
Vues:
21
there is a fault in VFP - you must tell VFP which 'ON' statment relates to which 'JOIN' statment ie:-

SELECT Payment.*, Instructor.*, Customer.*, Student.*;
FROM ls!payment LEFT OUTER JOIN ls!instructor;
ON Payment.pay_inst = Instructor.ins_inst;
LEFT OUTER JOIN ls!customer;
ON Payment.pay_acct = Customer.cus_acct;
LEFT OUTER JOIN ls!student;
ON Payment.pay_acct = Student.stu_acct and ;
Payment.pay_sub = Student.stu_sub

I hope this helps.

Alec Dearden.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform