Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 To: Alan Tuscano
  Where is Alan Tuscano?
 Manila
 Philippines
 Alan Tuscano
 Tags
Subject: RE: Order clause Invalid
Thread ID: 268692 Message ID: 268694 # Views: 36 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, July 14, 2010 3:33:10 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.


Maybe because of this line?

Select C.Code as InstCode from Bank ;


Should be:

Select C.Code as InstCode from Bank C ;   && you haven't created an alias for Bank


Also with alias, although it will work using A, B, C..... I prefer using T1, T2, T3..... If you use A, B, C.... what would happen if you reach M? Mdot rule will take over and VFP will treat m.Myfield not as tablename.fieldname but variable Myfield.



http://www.junblogs.com/
http://weblogs.foxite.com/sandstorm36/default.aspx
http://www.coderisland.com/forum/viewforum.php?f=10

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