Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order by Clause is Invalid
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Order by Clause is Invalid
Divers
Thread ID:
01001277
Message ID:
01001277
Vues:
71
I get ORDER BY CLAUSE IS INVALID when running under VFP9. what is wrong with the ORDER BY CLAUSE?
SELECT obligat.obligor, obligat.obligation, MIN(obligat.unit), MIN(obligat.name), MIN(obligat.loantype), ;
	MIN(obligat.lot), MIN(obligat.block), MIN(obligat.phase_unit), MIN(obligat.subdivsn), ;
	sum(disbtmp.loan_disb) as loan_disb, sum(disbtmp.inspfedisb) as inspfedisb,;
	MIN(obligat.inspfemoc), MIN(obligat.inspfecoll), MIN(obligat.inspfeincl), MIN(obligat.inspfeused),;
	sum(disbtmp.inspfetday) as inspfetday, sum(disbtmp.loan_fees) as loan_fees,;
	sum(disbtmp.disbddaamt) as disbddaamt;
	FROM obligat, disbtmp, obligor INTO table (rpt013b) ;
	WHERE disbtmp.obligor + disbtmp.obligation + disbtmp.unit =;
	obligat.obligor + obligat.obligation + obligat.unit;
	AND obligor.obligor = obligat.obligor ; 				
	AND disbtmp.loan_disb > 0;
	GROUP BY obligat.obligor, obligat.obligation ;
	ORDER BY obligat.name, obligat.obligor, obligat.subdivsn, obligat.phase_unit, ;		
	obligat.block, obligat.lot, obligat.obligation, obligat.unit 
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform