Re: SQL5001 error

Try this:

SELECT * FROM PUBWRK.CGARAREA A LEFT OUTER JOIN PUBWRK.WCUSTOMER B ON
A.CGSTREET# = B.WCSTREET#

In order to refer to specific tables you need to give them an alias (e.g.
a, b).

p.s.  The # in your column names might cause some SQL problems.  In general
it is a good practice to only use alpha-numeric characters in table/column
names.


Jim McLean



                                                                           
             RPower@xxxxxxxxxx                                             
             Sent by:                                                      
             java400-l-bounces                                          To 
             @midrange.com             "Java Programming on and around the 
                                       iSeries / AS400"                    
                                       <java400-l@xxxxxxxxxxxx>            
             25/05/2005 11:06                                           cc 
             AM                                                            
                                                                   Subject 
                                       SQL5001 error                       
             Please respond to                                             
             Java Programming                                              
             on and around the                                             
              iSeries / AS400                                              
             <java400-l@midran                                             
                  ge.com>                                                  
                                                                           
                                                                           




I'm using this statement in my java program and I'm getting a SQL5001
error.  Here's the statement:
getProps = conn.prepareStatement("SELECT * FROM PUBWRK.CGARAREA LEFT OUTER
JOIN PUBWRK.WCUSTOMER ON CGARAREA.CGSTREET# = WCUSTOMER.WCSTREET#");
The error I get is :java.sql.SQLException: [SQL5001] Column qualifier or
table CGARAREA undefined..
What am I doing wrong?  This is my first attempt at a JOIN SQL statement.

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
Tel: 709-576-8132
Email: rpower@xxxxxxxxxx
Website: http://www.stjohns.ca/
___________________________________________________________________________
Success is going from failure to failure without a loss of enthusiasm. -
Sir Winston Churchill
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.