SQL knowledge, was (Re: Válasz: AW: Another order by question ? / Thanks)

[rob@xxxxxxxxx]

I've dabbled in SQL for years.  But how is it recommended that I learn all
of these options?  When I studied in college it focused on specific
languages and database concepts were not part of the community college
scene.  But then again, I left a university with punched cards for a
community college with a S/34 and all the terminal time you wanted.  And I
don't miss programming fortran in which the disgruntled grad student wanted
to show off his knowledge of advanced calculus versus showing you the
programming concepts involved.
But please focus on SQL and not my rant on education.

Rob Berendt

==================
A smart person learns from their mistakes,
but a wise person learns from OTHER peoples mistakes.


                                                                                
                                       
                    Refaie.Heba@khb.h                                           
                                       
                    u                        To:     RPG400-L@midrange.com      
                                       
                    Sent by:                 cc:                                
                                       
                    owner-rpg400-l@mi        Subject:     Válasz: AW: Another 
order by question ? / Thanks             
                    drange.com                                                  
                                       
                                                                                
                                       
                                                                                
                                       
                    06/26/2001 08:53                                            
                                       
                    AM                                                          
                                       
                    Please respond to                                           
                                       
                    RPG400-L                                                    
                                       
                                                                                
                                       
                                                                                
                                       





Hi Group

Thanks for all the advices, I changed the statement to

 C/EXEC SQL
  C+   DECLARE @CURSOR1 CURSOR FOR
  C+   SELECT  file1.flda , file1.fldb , file1.fldc,
coalesce(file2.seqno,999)
  C+   FROM file1 LEFT JOIN file2
  C+   ON file1.fldb  = file2.fldb
  C+   AND file1.fldc = file2.fldc
  C+   ORDER BY coalesce(file2.seqno,999)
  C/EXEC SQL

and it works sharply...

All the best
Heba



+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---