470,626 Members | 2,139 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,626 developers. It's quick & easy.

SQL error at or before <EMPTY> ?

Hello,

Can anyone help me figure out what the SQL error below is caused by ?
Thanks for any help ....

Expand|Select|Wrap|Line Numbers
  1. SELECT CONCAT_KEY,                                     
  2.   COUNT(*)                                             
  3. FROM (SELECT DIST_NUMBER||AGT_NUMBER||AGT_INDEX        
  4.   AS CONCAT_KEY                                        
  5.   FROM H2591DB.TCSAU_EVMA                              
  6.   WHERE STATE = '20'                                   
  7.     AND GENERAL_STATUS = '1'                           
  8.     AND REASON_GENERAL IN ('A','B')                    
  9.     AND DIST_NUMBER = 'ERP')                           
  10.   GROUP BY CONCAT_KEY;                 
QUERY MESSAGES:
SQL error at or before <EMPTY> (line 9, position 29).
Jan 21 '07 #1
1 2320
FYI : I received an answer from another forum:

Expand|Select|Wrap|Line Numbers
  1. SELECT CONCAT_KEY,                                     
  2.   COUNT(*)                                             
  3. FROM (SELECT DIST_NUMBER||AGT_NUMBER||AGT_INDEX        
  4.   AS CONCAT_KEY                                        
  5.   FROM H2591DB.TCSAU_EVMA                              
  6.   WHERE STATE = '20'                                   
  7.     AND GENERAL_STATUS = '1'                           
  8.     AND REASON_GENERAL IN ('A','B')                    
  9.     AND DIST_NUMBER = 'ERP') X                                                
  10.   GROUP BY CONCAT_KEY;          
(I needed an 'X' at the end of line 9)
Jan 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

34 posts views Thread by Mark Moore | last post: by
2 posts views Thread by Fredrik Melin | last post: by
28 posts views Thread by Kent Feiler | last post: by
7 posts views Thread by Lorenzo Bettini | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.