Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Alan Tuscano
  Where is Alan Tuscano?
 Manila
 Philippines
 Alan Tuscano
 Tags
Subject: Order clause Invalid
Thread ID: 268692 Message ID: 268692 # Views: 36 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 3:25:54 AM         
   


Hi,

SELECT Datasrce, ;
		iNetwork, ;
		A.Source, ;
		BankName, ;
		BankCode, ;
		A.Service, ;
		MDR, ;
		iCount, ;
		AmtFee, ;
		Net, ;
		MLFee, ;
		Fee ;
	From curIssuerBn A ;
	Left Outer Join mchprof B ;
		On A.iNetwork = B.Network ;
		And A.Source = B.Source ;
		And A.Service = B.Service ;
		And A.Datasrce = B.DataScrc ;
	Union All ;
	Select C.Code as InstCode from Bank ;
	    Where C.Id = A.BankCode ;	    
	Group by A.iNetwork, A.Source, A.Service, A.Datasrce ;	
	Order by A.iNetwork, A.Bankcode ;	    
	Into Table curIssuer


Error : Order by Clause Invalid ??

Where's the Error or is the Select/Union Statement wrong?

Thanks.

Alan
Ad Majorem Dei Gloriam.

ENTIRE THREAD

Order clause Invalid Posted by Alan Tuscano @ 7/14/2010 3:25:54 AM
RE: Order clause Invalid Posted by Jun Tangunan @ 7/14/2010 3:33:10 AM
RE: Order clause Invalid Posted by Alan Tuscano @ 7/14/2010 4:51:20 AM
RE: Order clause Invalid Posted by Mike Yearwood @ 7/14/2010 5:49:45 AM
RE: Order clause Invalid Posted by Cetin Basoz @ 7/14/2010 11:46:05 AM
RE: Order clause Invalid Posted by Anders Altberg @ 7/14/2010 1:24:47 PM
RE: Order clause Invalid Posted by Christian Tabligan @ 7/14/2010 2:34:37 PM
RE: Order clause Invalid Posted by Samir H. @ 7/14/2010 3:21:51 PM
RE: Order clause Invalid Posted by Tamar Granor @ 7/14/2010 10:22:25 PM
RE: Order clause Invalid Posted by Christian Tabligan @ 7/15/2010 2:15:16 AM